Welcome to dbFreaks.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Databases with different encodings

 
   Database Help (Home) -> mySQL RSS
Next:  ODBC setup  
Author Message
Vangelis Natsios

External


Since: Feb 09, 2005
Posts: 1



(Msg. 1) Posted: Wed Feb 09, 2005 10:40 am
Post subject: Databases with different encodings
Archived from groups: mailing>database>mysql (more info?)

I run a MySQL Server (v. 4.1.5-gamma) from a binary distribution on a
SuSE 7.0 Linux. The default character set for the server is utf8 (runs
with the flag --default-character-set=utf8). The utf-8 encoded databases
I have seem to work fine. But I want to create another database with
greek (iso-8859-7) encoding from a dump from a 3.23.X server with
default character set "greek". Is this possible?

When I try to feed the dump into my server (mysql < DUMPFILE) as it is,
I see the greek but I can't get the sorting correct. When I change the
dump file (CREATE DATABASE ... CHARACTER SET greek) I cannot see the
greek text.

Furthermore, when I try to get the texts from a php page, I can't get it
right either way. Any ideas?

Also, is there a way to set the database encoding to something else than
the default in php? I see there' s a "mysql_client_encoding" function,
but no function like "set_mysql_client_encoding".

And another thing. I get the utf8-encoded greek correct on php pages
when I build php with "--with-mysql", which uses Client API version
3.23.49. If I build it with "--with-mysql=/usr/local/mysql" (where I
have installed MySQL 4.1.5) yielding Client API version "4.1.5-gamma" in
phpinfo(), I also get the greek text wrong (every character shows as
"?"). Is there something I should configure at the Client API, and how
do I do that?

Thanks in advance

Vangelis Natsios

 >> Stay informed about: Databases with different encodings 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
PLS HELP! - show databases and tables and columns - Hi, I just wonder if someone can help me with this: I need to create a sql script which will run when user installs/upgrades my app. User may already have the database and tables tructure setup on the server, or may not. The script needs to..

Restoring select databases/tables from an --all-databases .. - I use the --all-databases switch to backup my entire database. Sometimes there's a need to restore individual databases or tables form the backup file. What command should I use for this? Thanks, Raffi

Best way to issue hundreds of inserts/updates??? - Using mysql 4.0.23- What is the best way to execute several (hundreds of) inserts and updates? Rather than issuing tons of individual inserts and updates, can I send the strings to a text file and then have mysql do them all?? IE : query.txt insert..

MySQL freezes, brings XP machine to a grinding halt - I've been using MySQL for a while for fairly light database development on my XP machine. Currently, I am just starting a new project and have experienced some big problems with MySQL today both on my office machine and at home where running a particular...

login as user 'root' but do not have root privlages and my.. - Hi gang: I'm experiencing a problem with MySQL -- I updated MySQL from version 4.1.0 to 4.1.10 and now when I login as root it doesn't show all the databases I should have access to, nor it doesn't recognize me being logged in as root (via..
   Database Help (Home) -> mySQL All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]