נור דאוד schrieb:
Hello list,
I have a problem dumping a database. The problem is that the database uses the swedish charset (historical, hosting provider didn't have all sets). The data itself is Arabic (windows-1256), and although I have no idea how it is stored inside the database's files, the website's output is Arabic windows-1256.
if you have stored another charsets in a filed than the field is declared
as, than you need to change the charsets of this field without converting
the content
http://dev.mysql.com/doc/refman/5.1/en/charset-conversion.html
Now I am ready to move away from that provider, so I want to take a dump of the
data. I've tried many mysqldump options, but I always get a file full of
giberish. Using iconv on the file doesn't even work...
So my question is: How do you take a dump of a swedish-based database, and end up with a windows-1256 dump file??
with SET NAMES, you tell MySQL which charset it should use to return content
to you, or which charset has the content you send to the server
http://dev.mysql.com/doc/refman/5.1/en/charset-connection.html
--
Sebastian Mendel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
