MySQL Forums
Forum List  »  Character Sets, Collation, Unicode

Advanced Search
New Topic

Re: Problems with crypt Password in mySQL
Posted by: Peter Gulutzan
Date: February 01, 2007 09:37AM

I don't see what this has to do with encryption of passwords.
You inserted 'st†' in a CHAR column, you selected and got back '?st?', right?
This can happen if your character settings are wrong.
Find out what default character set your computer really uses.
Look at the encodings ("SELECT hex(column_name) ...").
Read the manual, especially the FAQ
"A.12. MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets"
http://dev.mysql.com/doc/refman/5.1/en/faqs-cjk.html
(Never mind that you're not Japanese, this has some generally-applicable tips.)

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Problems with crypt Password in mySQL
3583
Patrick Artner
January 29, 2007 09:54AM
Re: Problems with crypt Password in mySQL
2167
Peter Gulutzan
February 01, 2007 09:37AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.