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
Solaris Express Developer Edition [x86] is a wonderfully simple install. ~mm > > Thanks again > Martin-- > - Original Message ----- > From: "Michael Monaghan" <[EMAIL PROTECTED]> > To: "Bharat" <[EMAIL PROTECTED]> > Cc: > Sent: Wednesd

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 ne

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* e

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 s

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 t

Re: Restarting MySQL on Solaris 8?

2006-09-12 Thread Michael Monaghan
> - Original Message - > From: "Jay Paulson" <[EMAIL PROTECTED]> > To: > 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 someone co

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 MyS

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 version