|
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
Forum to discuss the use of the SalesLogix Web Platform, Client and Customer Portals, and the Application Architect (For version 7.2 and higher only). View the code of conduct for posting guidelines.
|
|
|
|
Saving japanese characters with SQL
Posted: 09 Dec 08 1:19 PM
|
I have some forms customized for the customer portal that insert tickets. The developer ended up using SQL as opposed to the entity model to get around a problem. The screen saves Japanese characteres as ?????????? (a string of question marks). Another screen using the entity model saves these characters fine so I am thinking it is the SQL that is messing up the storage of these characters..
Is there anything I can do to the page using SQL to get the japanese characaters to save correctly? Here is the code in question:
Sage.Platform.Data.IDataService service = Sage.Platform.Application.ApplicationContext.Current.Services.Get();
IDbConnection myConnection = service.GetConnection();
myConnection.Open();
IDbCommand MyCommand = myConnection.CreateCommand();
MyCommand.CommandText = "Insert into ticket (AlternateKeyPrefix, AlternateKeySuffix, ticketID, SECCODEID, contactID, accountID, ASSIGNEDTOID,ASSIGNED_TEAM, Area, URGENCYCODE, ReceivedbyID,StatusCode, AddKnowledge, UrgencyID, Got_Divx_Through, Created_From_Web, DivX_Language, Subject, Divx_Interface, viacode, serial_number) " +
"values ('" + AltKeyPrefix + "','" + AltKeySuffix + "','" + tickID + "', 'SYST00000001', '" + ContID + "','" + AccID + "','" + strTeamId + "','" + strTeamId + "', '" + sArea + "','3','SYST00000001', 'k6UJ9A0003N6', 'F', 'QLYMAA0001O4', '" + sGotThrough + "','T', '" + sLang + "','" + sSubject + "', '" + sInterface + "', 'k6UJ9A00007E', '" + serialNumber + "')";
using (IDataReader MyDataReader = MyCommand.ExecuteReader(CommandBehavior.CloseConnection))
{
} |
|
|
|
Re: Saving japanese characters with SQL
Posted: 15 Dec 08 3:05 AM
|
I don't know if this information can be useful:
The problem is in the way SalesLogix handles (or doesn't) nvarchar fields.
I tested visualization of Unicode characters (nvarchar SQL fields) for display only and I managed to have a tab working.
What I did:
1 - setup an extension of Contact entity (I displayed the strings in a Contact tab)
2 - add nvarchar fields to that table
3 - add those fields to the entity via the App Architect entity wizard.
The fields are recognized as Unicode Strings.
At this point, you can display those strings in a tab in SalesLogix Web. The ?????? are displayed because the Standard String field doesn't handle very well Unicode chars (standard fields are varchar, so Unicode is not supported at all).
From my limited experience, I can tell you that the display works (I did not check if edit works too).
I have to say that the management of Unicode fields is far from perfect. Anytime I rebuild all interfaces, the "Unicode String" type becomes "Ansi String" and the build fails (with an NHibernate/CLR Type error).
I have to remove and then re-add every nvarchar field from the entity wizard to reset the field type to "Unicode String".
So I think either I am doing something wrong or Unicode support is really immature.
Hope it helps. |
|
|
|
Re: Saving japanese characters with SQL
Posted: 15 Dec 08 12:18 PM
|
| Thanks Alberto. I actually ended up rewriting some of the inserts using the entity model and it is handling japanse characters fine. I tried a bunch of things with the SQL and Unicode characters with no luck. |
|
|
|
Re: Saving japanese characters with SQL
Posted: 16 Dec 08 4:10 AM
|
Nice to hear that japanese characters are handled fine.
Can I ask you how you setup fields on the database, on the entity model and on the form?
Just to know how you made it work.
Thank you in advance. |
|
|
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|