Re: using SET time_zone for localization

2006-01-18 Thread Gleb Paharenko
Hello. Perhaps this can resolve some queries: http://lists.mysql.com/mysql/177314 John Lauck wrote: > I'm using SET time_zone = 'US/Hawaii' to convert timezones and it's not > working. > > What am I doing wrong? > > I have verified that the session.time_zone var is set correctly. > > > if(

using SET time_zone for localization

2006-01-17 Thread John Lauck
I'm using SET time_zone = 'US/Hawaii' to convert timezones and it's not working. What am I doing wrong? I have verified that the session.time_zone var is set correctly. if(defined('ZMM_USER_LOCALE')) { $query = "SET time_zone = '" . mysql_real_escape_string(ZMM_USER_LOCALE) ."'; ";

Re: RE:Re: RE:Re: Localization..

2001-08-13 Thread SDiZ Cheng
charactors (Big5 or UTF-8 in that column.) which is simular to this example.. > > >- Original Message - > > >From: "shiuwaitai" <[EMAIL PROTECTED]> > >To: "SDiZ Cheng " <[EMAIL PROTECTED]> > >Cc: <[EMAIL PROTECTED]>

Re: RE:Re: Localization..

2001-08-09 Thread SDiZ Cheng
- Original Message - From: "shiuwaitai" <[EMAIL PROTECTED]> To: "SDiZ Cheng " <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, August 09, 2001 1:08 PM Subject: RE:Re: Localization.. > > Hi, > > try to use "varch

RE:Re: Localization..

2001-08-08 Thread shiuwaitai
Hi, try to use "varchar" or "varchar binary" instead. they work fine in my application for searching '%multibyte%multibyte%' condition even. >> Hi, >> >> >> >> I have used Solaris 2.6 (Unicode) and Windows 2000 (UTF8 supports Big5) as >> OS to run MySQL application. In my ex

Re: Localization..

2001-08-08 Thread SDiZ Cheng
> Date |Wed, 8 Aug 2001 03:05:20 +0800 > From |"SDiZ Cheng" <[EMAIL PROTECTED]> > > Hello! > > > SC> Yes, i have read that too. > SC> that tell me how to compile mysql with multi charset, > SC> but not create such kind of table. > > SC> i expect there is somthing like > SC> CREATE TABLE tbl_na

Re: Localization..

2001-08-08 Thread Grigory Bakunov
Date |Wed, 8 Aug 2001 03:05:20 +0800 >From |"SDiZ Cheng" <[EMAIL PROTECTED]> Hello! SC> Yes, i have read that too. SC> that tell me how to compile mysql with multi charset, SC> but not create such kind of table. SC> i expect there is somthing like SC> CREATE TABLE tbl_name ( SC> col_name type

Re: Localization..

2001-08-08 Thread SDiZ Cheng
> Hi, > > > > I have used Solaris 2.6 (Unicode) and Windows 2000 (UTF8 supports Big5) as > OS to run MySQL application. In my experience, I have not changed charset > parameter in server startup, database or column. They can store latin1 > and big5 properly "in-a-mix". > > Have u tested to i

Re: Localization..

2001-08-08 Thread shiuwaitai
Hi, I have used Solaris 2.6 (Unicode) and Windows 2000 (UTF8 supports Big5) as OS to run MySQL application. In my experience, I have not changed charset parameter in server startup, database or column. They can store latin1 and big5 properly "in-a-mix". Have u tested to insert and select

Re: Localization..

2001-08-07 Thread SDiZ Cheng
> Date |Tue, 7 Aug 2001 17:25:48 +0800 > From |"SDiZ Cheng" <[EMAIL PROTECTED]> > > Hello! > > > SC> I have read these docs. I can't find any charset option in CREATE TABLE > SC> syntax. > Oh no. > You need to set up charset in mysql configuration. > like this: > http://www.mysql.com/doc/C/h/Ch

Re: Localization..

2001-08-07 Thread SDiZ Cheng
> Date |Tue, 7 Aug 2001 17:25:48 +0800 > From |"SDiZ Cheng" <[EMAIL PROTECTED]> > > Hello! > > > SC> I have read these docs. I can't find any charset option in CREATE TABLE > SC> syntax. > Oh no. > You need to set up charset in mysql configuration. > like this: > http://www.mysql.com/doc/C/h/

Re: Localization..

2001-08-07 Thread Grigory Bakunov
Date |Tue, 7 Aug 2001 17:25:48 +0800 >From |"SDiZ Cheng" <[EMAIL PROTECTED]> Hello! SC> I have read these docs. I can't find any charset option in CREATE TABLE SC> syntax. Oh no. You need to set up charset in mysql configuration. like this: http://www.mysql.com/doc/C/h/Character_sets.html

Re: Localization..

2001-08-07 Thread SDiZ Cheng
- Original Message - From: "Grigory Bakunov" <[EMAIL PROTECTED]> To: "SDiZ Cheng" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, August 07, 2001 1:16 PM Subject: Re: Localization.. > Date |Tue, 7 Aug 2001 04:01:17 +0800 > From

Re: Localization..

2001-08-06 Thread Grigory Bakunov
Date |Tue, 7 Aug 2001 04:01:17 +0800 >From |"SDiZ Cheng" <[EMAIL PROTECTED]> Hello! SC> I have a table which contain data of some different charsets, SC> some of them are multi-byte character.. SC> They are currently stored in raw, binary format.. SC> In order to make % match those multi-byte ch

Localization..

2001-08-06 Thread SDiZ Cheng
I have a table which contain data of some different charsets, some of them are multi-byte character.. They are currently stored in raw, binary format.. In order to make % match those multi-byte characters correctly, I am planning to convect the table format to correct charset. However, i cannot fi

Re[2]: Localization with MySQL

2001-07-08 Thread Werner Stuerenburg
This is how I did it on http://kuehnle.de I don't rely on browser information, though. I let users make their choice. I didn't try to find a single solution for all purposes. Instead, I have a general translation table 'strings' for words or sentences that normally would appear in my code and th

Re: Localization with MySQL

2001-07-07 Thread tj marlin
he 'jp' field, since that language requires (as I >understand it) 'double' characters to drive it. I intend to drive the >content by (1) selecting the language according to the 'Accept-Language' >variable in the user's browser OR (2) allowing the user

Localization with MySQL

2001-07-07 Thread Nelson Goforth
ve it. I intend to drive the content by (1) selecting the language according to the 'Accept-Language' variable in the user's browser OR (2) allowing the user to select a language manually. Obviously I'm not up to speed on the exact requirements of localization and using oth

Localization

2001-02-21 Thread Lisle Robins
I sent this a couple of weeks ago at the time I joined the list, but I didn't see it. Please excuse if it is a duplicate, but I still need to know the answer. I am localizing (in French) a Delphi MySQL application which uses the Zeos components which in turn use libmysql.dll. Can anyon

Localization

2001-02-12 Thread Lisle Robins
I am localizing (in French) a Delphi MySQL application which uses the Zeos components which in turn use libmysql.dll. Can anyone suggest how to translate the login dialog screen and other messages in libmysql.dll? Is there already a French version around? Thanks. Lisle Robins