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.)

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Problems with crypt Password in mySQL
2167
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.