Re: How to create a unicode capable table??

2008-12-05 Thread Michael Monaghan
I'm not at all familiar with SQL Server, but you need to make sure that the encoding/charset you use in MySQL is the same as used in SQL S. If not the same, then you might need to transcode the data before migrating. Collation is less important than encoding. - if you get the charset wrong, then

Re: Arabic text storing problem

2007-11-14 Thread Michael Monaghan
i have one problem with Arabic text. I have created database with charaterset utf8. when i insatal sql file all the content which is arabic that content stored as arabic. but when i retrieve When you retrieve this content, how are you viewing it? - browser? terminal? For the browser, it

Re: Arabic text storing problem

2007-11-14 Thread Michael Monaghan
Developer Edition [x86] is a wonderfully simple install. ~mm Thanks again Martin-- - Original Message - From: Michael Monaghan [EMAIL PROTECTED] To: Bharat [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Wednesday, November 14, 2007 9:39 AM Subject: Re: Arabic text storing problem

Re: To see Asian Characters in mysql

2007-07-29 Thread Michael Monaghan
I can't speak to your GUI tool, but here's some general pointers: 1. You have to be absolutely sure that your system can in fact render Myanmar. - so ensure that at least your browser can view proper Myanmar characters - see http://www.columbia.edu/kermit/utf8.html. This page has a sample Burmese

Re: multilanguage web application with mysql database?

2007-05-04 Thread Michael Monaghan
I have many tables like the table Person:below, in mysql database. person_id, first_name,last_name, mi, gb_first_name, gb_last_name, b5_first_name, b5_last_name, gender, dob where different columns storing strings in different encodings. All the strings/fields etc. need to be in the *same*

Re: Mmultiple languages in the MySQL database

2006-09-28 Thread Michael Monaghan
On 9/28/06, Jerry Schwartz [EMAIL PROTECTED] wrote: We have multiple Western languages in our UTF-8 data base, without a problem. Right now I'm working on adding Chinese data, but my major problem is reading back what's in there to find out if it went in correctly :( One thing I've done in the

Re: Mmultiple languages in the MySQL database

2006-09-28 Thread Michael Monaghan
One thing I've done in the past to verify this exact issue, is to simply run something like: # mysql -e select fields from table output.txt - making sure that the the output contains some non-ASCII characters - preferably non-Latin too. Then open output.txt in a browser and set the

Re: Restarting MySQL on Solaris 8?

2006-09-12 Thread Michael Monaghan
- Original Message - From: Jay Paulson [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Friday, September 08, 2006 9:51 PM Subject: Restarting MySQL on Solaris 8? A couple questions since I'm not a Solaris person I really don't know how to do the following and was hoping that

Re: Running Two Different Versions of MySQL

2006-05-30 Thread Michael Monaghan
Ah yes, the docs. - Thank you. ~mm On 5/30/06, sheeri kritzer [EMAIL PROTECTED] wrote: http://dev.mysql.com/doc/refman/5.0/en/multiple-servers.html -Sheeri On 5/29/06, Michael Monaghan [EMAIL PROTECTED] wrote: Hi, I have a machine [Solaris 9 x86] that has MySQL v3.22.xx installed. I am

Running Two Different Versions of MySQL

2006-05-29 Thread Michael Monaghan
Hi, I have a machine [Solaris 9 x86] that has MySQL v3.22.xx installed. I am not familiar with the applications [quite a few] that use this instance. I need to install an application that requires a newer version of MySQL. I plan to install v5.x. separately - rather than upgrade the old