Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

Problem Uploading Tokens with Special Characters

  • kripp88
  • kripp88's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
9 years 4 months ago #113629 by kripp88
I am trying to upload tokens to a survey and sometimes certain fields contain special characters such as a "long dash" —. I see the error, "CDbCommand failed to execute the SQL statement: CDbCommand failed to prepare the SQL statement: SQLSTATE[IMSSP]: An error occurred translating the query string to UTF-16: No mapping for the Unicode character exists in the target multi-byte code page."

Do I need to set the default charset to UTF-16 in php or is this a LimeSurvey bug?

Thanks,
Kyle
The topic has been locked.
  • c_schmitz
  • c_schmitz's Avatar
  • Offline
  • LimeSurvey GmbH Employee
  • LimeSurvey GmbH Employee
More
9 years 4 months ago #113630 by c_schmitz
Replied by c_schmitz on topic Problem Uploading Tokens with Special Characters
What version & build are you using?

Best regards

Carsten Schmitz
LimeSurvey project leader
The topic has been locked.
  • kripp88
  • kripp88's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
9 years 4 months ago #113632 by kripp88
Oh I apologize for leaving that info out. We are on Version 2.00+ Build 130802

-Kyle
The topic has been locked.
  • c_schmitz
  • c_schmitz's Avatar
  • Offline
  • LimeSurvey GmbH Employee
  • LimeSurvey GmbH Employee
More
9 years 4 months ago #113633 by c_schmitz
Replied by c_schmitz on topic Problem Uploading Tokens with Special Characters
You should do a clean install of the latest version (do not just update your existing one) and then port the survey to the new installation. There has been a DB change for 2.05 and MSSQL (that cannot be applied to existing installations) which should mitigate this problem.

Best regards

Carsten Schmitz
LimeSurvey project leader
The topic has been locked.
  • kripp88
  • kripp88's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
9 years 4 months ago #113634 by kripp88
Thank you, I will look into that
The topic has been locked.
  • kripp88
  • kripp88's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
9 years 4 months ago #113707 by kripp88
Is there anyway you can point me in the direction of the issue number or fix that was used to solve this problem? I would prefer to apply this change manually if possible by altering the php/database rather than have to go through a clean install since we have so many surveys with thousands of active tokens at any given time.

Thanks,
Kyle
The topic has been locked.
More
7 years 9 months ago #136702 by ChacoKevy
Replied by ChacoKevy on topic Problem Uploading Tokens with Special Characters
Does anyone have access to an MSSQL install to replicate an error? I have exactly this problem, but on a clean 2.50 Build 160517. Attached is a csv that has an apostrophe with formatting carried over from Word (curved apostrophe instead of the dagger-straight-down apostrophe). This formatting fails the upload if the selected character set of the file is Automatic, or converts it to a question mark if I select UTF-8 Unicode. That would ruin my data validation after export.
Attachments:
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Away
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
7 years 9 months ago #136863 by DenisChenu
Replied by DenisChenu on topic Problem Uploading Tokens with Special Characters
Carsten have a mssql server ONLY for testing : if you have a clean/clear bug report to do : www.limesurvey.org/community-services/bug-tracker

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose