Welcome to the LimeSurvey Community Forum

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

Problem Uploading Tokens with Special Characters

More
10 years 10 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.
More
10 years 10 months ago #113630 by c_schmitz
What version & build are you using?

Best regards

Carsten Schmitz
LimeSurvey project leader
The topic has been locked.
More
10 years 10 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.
More
10 years 10 months ago #113633 by c_schmitz
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.
More
10 years 10 months ago #113634 by kripp88
Thank you, I will look into that
The topic has been locked.
More
10 years 10 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
9 years 3 months ago #136702 by ChacoKevy
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.
The topic has been locked.
More
9 years 3 months ago #136863 by DenisChenu
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 support - Plugins, theme and development .
I don't answer to private message.
The topic has been locked.
Moderators: holchtpartner

Lime-years ahead

Online-surveys for every purse and purpose