[MonetDB-users] Copy command and CHAR field.
what are valid characters that can go into the char fields? i am trying to migrate from mysql 4.1 and my data doesn't make it in. If i strip out some the the characters it makes it. The string is C�e dIvoire. which is the ivory coast. its a pain to clense, but i just wanted to know what a valid character is.
On Fri, Apr 06, 2007 at 03:37:01PM -0500, Todd Gruben wrote:
what are valid characters that can go into the char fields? i am trying to migrate from mysql 4.1 and my data doesn't make it in. If i strip out some the the characters it makes it. The string is C�e dIvoire. which is the ivory coast. its a pain to clense, but i just wanted to know what a valid character is.
Valid characters are UTF-8 characters. It seems your string isn't valid utf-8 (at least my mail agent doesn't understand it). Niels
------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- Niels Nes, Centre for Mathematics and Computer Science (CWI) Kruislaan 413, 1098 SJ Amsterdam, The Netherlands room C0.02, phone ++31 20 592-4098, fax ++31 20 592-4312 url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl
participants (2)
-
Niels Nes -
Todd Gruben