8/17/2025 2:30:30 PM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
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.
|
|
|
|
Handling Unicode/nvarchar fields
Posted: 28 Jan 09 8:19 AM
|
Anyone knows how to handle Unicode/SQL Nvarchar data?
If I try to add an nvarchar field to an Entity (say Contact, just to keep things simple) via the Update Property command in Application Architect, the default field type is set to "Unicode String".
If I build and deploy the platform at this point, I am able to display Unicode data correctly in the Web Client (japanese/corean/chinese, etc.).
However, if I restart Application Architect and reopen the Contact Entity, the field type is set to "AnsiString". From now on, every clean build throws an error of "type not recognized".
In fact, if I try to change the property type, I can't find Unicode String as an available type. As a side note, I found a Unicode String Type via Reflector, which seems to handle Unicode just fine (don't know if UTF-16 or only UCS-2).
Is this correct or a bug (or just my test platform)?
How can I support Unicode for read/write purposes? This is MANDATORY in 2009 for many installations.
Is the SP1 going to fix at least some of this issues?
Many thanks to everyone 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!
|
|
|
|
|
|
|
|