On Jun 27, 2006, at 2:56 AM, [EMAIL PROTECTED] wrote:
I'm using the ODBCDatabase class to talk to a FileMaker Pro 8
database, and
I need to write (and read) unicode data.
In order to get this to work I !!think!! I need to set a connection
attribute on the ODBC driver that I'm using, telling it that I'm about
to
use UTF8/16. I think this may be possible using the ODBCDatabase
'Attribute' and 'AttributeString' properties but I'm very unsure on
how to
use it.
Does anyone have any experience in this area and can tell me how to use
these elements?
The Attribute and AttributeString properties are used together to
specify the value of a single string connection parameter prior to
establishing a connection to the database. Here is an example:
Const SQL_CURRENT_QUALIFIER = 109
Dim db As New ODBCDatabase
db.Attribute = SQL_CURRENT_QUALIFIER
db.AttributeString = "NorthWind"
If db.Connect Then
' ...
End If
I don't think you need to use this feature in this case. The FMP ODBC
driver always uses UTF-8 (the Mac driver does, anyway). You just need
to make sure the strings use pass to SQLExecute and SQLSelect are
encoded as UTF-8, and you should be OK.
Jonathan Monroe
Actual Technologies - ODBC for OS X
http://www.actualtechnologies.com
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
