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

Your Cart

LassoSoft >

LassoDocs >

LassoTalk >

RhinoTrac

LassoSoft Ticket Tracking System

Lasso 9 Issues

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

Comments

Latest Method or Type

View Types and Methods

LassoSoft Inc. > Home