Passing Unicode strings to Database 
Author Message
 Passing Unicode strings to Database

[Env: Win2k, python 1.5.2]

Hi people!

I have a string in Japanese encoded in UTF8. I need to put it into
database in Unicode form.

import dbi, odbc
o=odbc.odbc(self.ODBC_name+"/"+self.ODBC_sql_username+"/"+self.ODBC_sql_password)
c=o.cursor()
runes = UTF82Runes(string.replace(self.pr_table[row]["description"],"'","''"))
operator="""INSERT INTO %s VALUES('%s','%s');"""%(self.ODBC_table,
   int(self.pr_table[row]["pr_no"]),
   runes.tostring())
c.execute(operator)    # update database

I'm getting the following error trace:

Traceback (innermost last):
  File "C:\dev\Products\MRATES~1\server.py", line 34, in ?
    PR.sync_all()
  File "C:\dev\Products\MRATES~1\PRML\code\prml.py", line 2837, in sync_all
    self.__sync_with_sql__(i)
  File "C:\dev\Products\MRATES~1\PRML\code\prml.py", line 2797, in __sync_with_sql__
    c.execute(operator)    # update database
TypeError: argument 1: expected string without null bytes, string found

runes is array.array('H') containing Unicode string.

Database string field has "ntext" type. How can I overcome this
problem?

Thanks in advance,
Mick.



Sun, 22 Aug 2004 19:11:17 GMT  
 Passing Unicode strings to Database

Quote:

> runes is array.array('H') containing Unicode string.

> Database string field has "ntext" type. How can I overcome this
> problem?

I recommend to use Python 2.x, and use Unicode objects to represent
Unicode strings. For Python 1.5, if you are using the Win32
extensions, you can also try to use Mark's Unicode type.

Regards,
Martin



Mon, 23 Aug 2004 16:58:37 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Passing Unicode strings to Database

2. ANNOUNCE: unicode 0.4, command line unicode database query tool

3. Tkinter wart: returned texts are sometimes strings, sometime Unicode strings

4. unicode strings and strings mix

5. How does one pass Unicode command line arguments to Tcl program (Windows 2000)

6. Unicode strings

7. Unicode to string conversion HELP

8. Unicode strings

9. Unicode strings

10. Unicode strings

11. Unicode string for the standard library ?

12. unicode to 'normal' string conversion

 

 
Powered by phpBB® Forum Software