Hi All,
Well it turns out this has less to do with nulls and more to do with nchar and nvarchar holding Unicode strings (UTF-16). The database (not owned by us) is being changed so the problem should go away. Sorry for the noise and thanks for reading.
Lou
On Monday, May 12, 2014 12:19:01 PM UTC-4, Louis LaBrunda wrote:
Hi Guys,
Does any one know anything about SQL nchar (MS/SQL through ODBC and maybe others) definition? I have to access a database with nchar and nvchar columns defined. When I read a value from an nchar defined column I get a null terminated string (even for nchar(1) which seems to me to be a really dumb column type in the first place).
I don't need to pass this data to the OS so, I'm thinking of looking for a way to get the null trimmed when the column is read. Maybe by changing a table in AbtOdbcDatabaseManager.
Any thoughts?
Lou
--
You received this message because you are subscribed to the Google Groups "VA Smalltalk" group.
To unsubscribe from this group and stop receiving emails from it, send an email to
[hidden email].
To post to this group, send email to
[hidden email].
Visit this group at
http://groups.google.com/group/va-smalltalk.
For more options, visit
https://groups.google.com/d/optout.
Locked
