Lasso Soft Inc. > Home

RhinoTrac

LassoSoft Ticket Tracking System

NOTE: If you are using Lasso Server 9.3 please Log your ticket directly via the LUX admin as this will give us more information about your issue.

Lasso 9 Issues



Ticket #7262: SQL Server can't handle multibyte UTF8

Reported by:
Paul Higgins
Date:
27 Oct, 2009
Priority:
minor
Component:
Lasso 9
Version:
Keywords:
Platform:
Using FreeTDS ODBC from Macports, SQL Server can't handle multibyte UTF8.

Comments

27 Oct, 2009 by Paul Higgins
Error Code: 8005
Error Message: 42000 [FreeTDS][SQL Server]The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Parameter 4: The parameter name is invalid. HY000 [FreeTDS][SQL Server]Error converting characters into server's character set. Some character(s) could not be converted
Error Stack:
28 Oct, 2009 by Paul Higgins
I got it to return values correctly. Will document info.
28 Oct, 2009 by Paul Higgins
Actually, some clarification is needed. I did not get -add to work. I did however get an INSERT statement to work correctly using the -sql param.
28 Oct, 2009 by Paul Higgins
When using the -sql parameter, a nChar, nVarchar, or nText, the text must be preceded by the letter N.

So, ('my japanese') would be (N'my japanese').

If the N is not used, the query will work, but will not be retreived correctly, which I guess means that it was not inserted correctly.
06 Nov, 2009 by Paul Higgins
Is there a way to force nvarchar, ntext, nchar fields to use N'' when inserting?
Please log in to your LassoSoft account to comment

LassoSoft Inc. > Home

 

 

©LassoSoft Inc 2015 | Web Development by Treefrog Inc | Privacy | Legal terms and Shipping | Contact LassoSoft