| View previous topic :: View next topic |
| Author |
Message |
dnamroud
Guru
Joined: 01 Jun 2005
Posts: 346
Location: Canada
|
 Posted: Fri Apr 27, 2007 1:23 pm Post subject: [SOLVED] MySQL 4.1.22 and characters (latin1) |
 |
|
Hello
I am upgrading my DB from 4.0.27 to 4.1.22 and than to 5.0
I am following the guide http://www.gentoo.org/doc/en/mysql-upgrading.xml
I already change all occurrences of utf8 with latin1 as my DB is containing an non-ASCII characters...
| Quote: |
Important: The default character set in MySQL 4.1 and above is utf8. If the data contain non-ASCII characters, you may want to preserve the default character set of the database replacing all occurrences of utf8 with latin1 in the /etc/mysql/my.cnf config file. More information can be found Charset conversion chapter. |
My problem is :
when i try to login into my application, my system is not recognizing my encrypted password...
I did many tests and here is what i am seeing:
1- My sytem is able to read a stored field containing an accent like à é, è,...
2- when trying to update or insert a new field containing accent character, It looks like ok, but when looking into my MySQL, this field is not inserted correctly, the only characters that i can see are the only ones written before the first character with accent...
Probably it's a question of upgrading and converting between latin1 and utf-8... but i don't know how to solve it..
Do you have any ideas that can help me to fix it...
Thank you
Dany
Last edited by dnamroud on Thu May 03, 2007 6:09 pm; edited 1 time in total |
|
| Back to top |
|
 |
sp7xfq
n00b
Joined: 28 Dec 2005
Posts: 60
Location: Poland, Kielce
|
| Posted: Sat Apr 28, 2007 7:18 am Post subject: |
|
|
Hi,
Have you complied mysql with latin1 use-flag?
_________________
Andrzej Sobczyk
Feel free to correct my English |
|
| Back to top |
|
|
dnamroud
Guru
Joined: 01 Jun 2005
Posts: 346
Location: Canada
|
| Posted: Thu May 03, 2007 6:09 pm Post subject: |
|
|
not really, according to the manual..
However after merging mysql with latin1 it looks like working fine
Thanx a lot
Dany |
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
Networking & Security
