MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Stefan Klopp Date:July 22 2004 4:09pm
Subject:Re: after upgrade unicode characters changed to question marks
View as plain text  
Hello,

I had checked the variables on both the 3.23 and 4.0.18 and they both show
the exact same character sets. Nothing appears to have changed with our data
in the tables or the setting of the server.

Here is what the show variables reports:

| character_set         | latin1|
| character_sets       | latin1 big5 czech euc_kr gb2312 gbk latin1_de sjis
tis620 ujis dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish
hebrew win1251 estonia hungarian koi8_ukr win1251ukr greek win1250 croat
cp1257 latin5 |
| convert_character_set| |

Stefan

----- Original Message ----- 
From: <valentin_nils@stripped>
To: "Stefan Klopp" <stefan@stripped>
Cc: <mysql@stripped>
Sent: Wednesday, July 21, 2004 5:36 PM
Subject: Re: after upgrade unicode characters changed to question marks


> Hi Stefan,
>
> sorry if this is an insulting question, but did perhaps the character set
> change for the "orginal tables" during the upgrade ?
>
> You can use the following command (on 4.x) to confirm the settings:
>
> SHOW CREATE TABLE;
> SHOW CREATE DATABASE;
> SHOW VARIABLES LIKE "%char%";
>
> Please also note this documentation:
>
> http://dev.mysql.com/doc/mysql/en/Charset-upgrading.html
> http://www.be-known-online.com/mysql/
>
http://www.be-known-online.com/mysql/UC-2004/Using_MySQL_in_a_Japanese_environment.pdf
>
> I hope this helps.
>
> Best regards
>
> Nils Valentin
>
>
> > Hello All,
> >
> > We recently upgraded our mysql server from 3.23 to 4.0.18 and have found
> > that all of our Unicode characters are now being displayed as question
> > marks
> > (?). Anyway this only happens when viewing over the web as when we view
> > via
> > the shell mysql we can see the characters fine. In addition if we update
> > our
> > information in the database or insert new Unicode data we have no
problems
> > seeing it. Basically it is just the old data that is in the database
that
> > we
> > have problems seeing via the web. Any ideas would be great.
> >
> > Stefan Klopp
> >
> >
> >
> > ---
> >
> > Checked by AVG anti-virus system (http://www.grisoft.com).
> > Version: 6.0.725 / Virus Database: 480 - Release Date: 19/07/2004
> >
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> > http://lists.mysql.com/mysql?unsub=1
> >
> >
>


---

Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.725 / Virus Database: 480 - Release Date: 19/07/2004

Thread
after upgrade unicode characters changed to question marksStefan Klopp21 Jul
  • Re: after upgrade unicode characters changed to question marksJean-Marc PULVAR22 Jul
  • Re: after upgrade unicode characters changed to question marksStefan Klopp22 Jul
  • Re: after upgrade unicode characters changed to question marksStefan Klopp22 Jul
  • Re: after upgrade unicode characters changed to question marksEgor Egorov26 Jul