MySQL Character Set
I need in depth information on the character set used by MySQL including invisible/escape characters/codes. Is there online documentation that I can read on this? Thanks. - Asad -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Character Set
Hello. This page contains information about escape characters: http://dev.mysql.com/doc/mysql/en/string-syntax.html The general information about character set could be found at: http://dev.mysql.com/doc/mysql/en/charset.html Asad Habib [EMAIL PROTECTED] wrote: I need in depth information on the character set used by MySQL including invisible/escape characters/codes. Is there online documentation that I can read on this? Thanks. - Asad -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mySQL character set problem
Hi, I have just found a major problem with my site. This is my problem: My server has been running on a redhat 7.3 distro without any problems for some time now. I then purchased a new server, which is running Redhat Linux ES 3.0 with the same basic settings and same install options. When performing a mysql dump of the database, and uploading this to the new server, all of the special scandinavian characters are beeing replaced with somthing that looks like chineese or something. Everything else works great. Somewhere i need to change som language coding, but I'm not sure where to do this. I have checked the charset directory and there are many options there allready. I then tried to include the following in my /etc/my.cnf file: default-character-set=latin1(Also tried the default swe7) But this did not solve my problem. Both Linux distro's are installed with English language and Norwegian/Swedish extra language support + Norwegian keymap. Hope someone can help me work this out. System config: Old-server: RH 7.3 with mysql Ver 11.18 Distrib 3.23.58, for pc-linux (i686) New server: RHEL ES 3.0 with mysql Ver 11.18 Distrib 3.23.58, for redhat-linux-gnu (i386) Terje D Norway -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mySQL character set problem
The first things you should check: 1. Do \s from the mysql client to be sure its using the character set you told it to use with default-character-set=latin1. Be sure its the same one you used on your old server. 2. Since you have the Norwegian keyboard set up try typing Norwegian characters in the terminal. If they are displayed as expected then you know that the terminal font is not the problem. Having an improper terminal font is often the problem in cases like this. 3. Select the hex values for the characters which are not being displayed. SELECT hex(Norwegian_column) FROM your_table; If your old system is still available compare these values to the working system, just to be sure your data wasn't corrupted somewhere in the transfer. 4. Test with multiple clients if possible. Such as the command line client and a php web client. Hope this helps, Jeremy _ Let the new MSN Premium Internet Software make the most of your high-speed experience. http://join.msn.com/?pgmarket=en-uspage=byoa/premST=1 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]