Unicode with CL-SQL, Oracle and SBCL

Elias MÃ¥rtenson <[email protected]> Fri, 16 Dec 2011 18:47:12 +0800
Newsgroups gmane.lisp.clsql.general
Message-ID <CADtN0WL7wtUUX1PqZZGctJq3DE-d8WQZ0uG9HQcS+V96Or=LoA@mail.gmail.com>
Hello,

I'm having no end of problems getting non-ASCII characters to work in with
Oracle 10g and SBCL.

For example, if I try to insert #\SNOWMAN (U+2603) it inserts a Control-C
character into the column. Other strings (chinese, for example) retults in
garbage being inserted that can't be decoded when trying to select it back.

I guess my main question right now is: Is this supposed to work at all? Has
anyone tested non-ASCII characters with Oracle? And if yes, what's the
secret to getting it to work?

I'm using AL32UTF8 for the NLS_LANG setting, but I've tried various other
settings too to no avail.

Thanks and regards,
Elias

_______________________________________________
CLSQL mailing list
[email protected]
http://lists.b9.com/cgi-bin/mailman/listinfo/clsql