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