- Posts: 22
- Thank you received: 0
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
Problem Uploading Tokens with Special Characters
- kripp88
- Topic Author
- Offline
- Junior Member
Less
More
9 years 6 months ago #113629
by kripp88
Problem Uploading Tokens with Special Characters was created 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
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
- Offline
- LimeSurvey GmbH Employee
Less
More
- Posts: 302
- Thank you received: 84
9 years 6 months ago #113630
by c_schmitz
Best regards
Carsten Schmitz
LimeSurvey project leader
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
- Topic Author
- Offline
- Junior Member
Less
More
- Posts: 22
- Thank you received: 0
9 years 6 months ago #113632
by kripp88
Replied by kripp88 on topic Problem Uploading Tokens with Special Characters
Oh I apologize for leaving that info out. We are on Version 2.00+ Build 130802
-Kyle
-Kyle
The topic has been locked.
- c_schmitz
- Offline
- LimeSurvey GmbH Employee
Less
More
- Posts: 302
- Thank you received: 84
9 years 6 months ago #113633
by c_schmitz
Best regards
Carsten Schmitz
LimeSurvey project leader
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
- Topic Author
- Offline
- Junior Member
Less
More
- Posts: 22
- Thank you received: 0
9 years 6 months ago #113634
by kripp88
Replied by kripp88 on topic Problem Uploading Tokens with Special Characters
Thank you, I will look into that
The topic has been locked.
- kripp88
- Topic Author
- Offline
- Junior Member
Less
More
- Posts: 22
- Thank you received: 0
9 years 6 months ago #113707
by kripp88
Replied by kripp88 on topic Problem Uploading Tokens with Special Characters
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
Thanks,
Kyle
The topic has been locked.
- ChacoKevy
- Offline
- Junior Member
Less
More
- Posts: 25
- Thank you received: 0
7 years 11 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
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13643
- Thank you received: 2491
7 years 10 months ago #136863
by DenisChenu
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.
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.