September 2008 - postmodern-devel - mailman3.common-lisp.net

[postmodern-devel] Storing Lists
by Mark Slamin 29 Sep '08

29 Sep '08

How do I insert a list into a single field of a single record in the database? Trying to insert (A B C) yields type errors if database type is set to text or varchar. Is there another data type I should use? Does the list need to be modified somehow? I need to be able to store and retrieve a list as easily as possible. Thanks. Mark Slamin

4 4

[postmodern-devel] Create-table dynamic table name
by Mark Slamin 21 Sep '08

21 Sep '08

Hi. How do I use a variable as a table name with create-table? The following always takes 'tableName' as the name rather than the value of tableName: (sql (:create-table tableName ((name :type string) (address :type string)))) :raw doesn't seem to work. Thanks Mark

2 1

[postmodern-devel] character encoding
by Roman Budzianowski 11 Sep '08

11 Sep '08

I am trying to retrieve records from a db with SQL_ASCII. Any advice on how to deal with it? I don't see a way to change the encoding for a connection. Invalid byte at start of character: 0x99 [Condition of type TRIVIAL-UTF-8:UTF-8-DECODING-ERROR] I don't think I can change the encoding of the db. Roman

2 8