----- Original Message ----- From: "Victoria Reznichenko" <[EMAIL PROTECTED]> Sent: Thursday, December 18, 2003 1:36 PM Subject: Re: Fw: Bug in 4.1.1 Internationalization on Windows2000 ? > You can use: > SELECT SUBSTRING_INDEX(CONVERT(USER() USING cp1251),'@',1); > SELECT SUBSTRING_INDEX(USER(),_utf8'@',1); >
Thanks! In this case I need to rewrite all client apps, something a kind of SELECT SUBSTRING_INDEX(USER(),/*!40100 _utf8*/'@',1); - at this point I rely on it that server ALWAYS must be under utf8. IMHO, explicit using of such constants in program code is very bad style: servers as well as clients can have different codepages (cp1251, koi8r etc (for me)). Why not return result of system functions according 'character_set_server' variable by deault? IMHO, it would be more correctly. WBR! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]