Jun 04, 2014; 13:28
Francesco Badaloni
Cyrillic text in MySql DB table
Jun 04, 2014; 05:46
Tim Taplin
Re: Cyrillic text in MySql DB table
Jun 04, 2014; 13:05
James Harvard
Re: Cyrillic text in MySql DB table
Jun 04, 2014; 14:13
Francesco Badaloni
Re: Cyrillic text in MySql DB table
Hi Tim,
if I insert the cyrillic characters directly to the mysql table, (using Navicat), the result is the same.
I see the question marks in the table directly.
this is an example:
Трансфер из аэропорта Фьюмичино (FCO) в Рим, 1-3 pax, Приватный сервис, Van/Sedan
the text is stored in a "var" in session and then stored in field_two.
then I put it in a PDF and the question marks disappear.
What I get is the following:
(FCO) , 1-3 pax, , Van/Sedan
francesco
Il giorno 04/giu/2014, alle ore 13:46, Tim Taplin ha scritto:
> can you provide the cyrillic text? what happens if you insert the cyrillic characters directly to the mysql table, using a client like Sequel Pro or Navicat?
>
> Assuming that the text is collected from a form, and field_two is the text?
>
> Are you seeing the question marks in the table directly? or when you retrieve the text? or both?
>
> Not sure if I have any answers but perhaps a few more details will more people involved in the discussion.
>
> Tim Taplin
>
> On Jun 4, 2014, at 5:28 AM, Francesco Badaloni <f.badaloni@graffitinet.it> wrote:
>
>> Hi All,
>>
>> we can not in any way get a MySql table accept Cyrillic text.
>> The text is not coded right. What we get is questions marks for any cyrillic char.
>>
>> ????????? ???????? ?? / ? ????? ????, 1-8 pax, ????????? ??????, Van
>>
>> The DB is:
>> Default Character Set: utf8
>> Default Collation: utf8_general_ci
>>
>> The table is:
>> Default Character Set: utf8
>> Default Collation: utf8_general_ci
>>
>> On Lasso Administration the table is:
>> UTF-8 (Unicode)
>>
>> This is the simple inline:
>>
>> [inline: -database='DB', -table='table', -keyfield='ID', -add, 'field_one'=($ID_cliente), 'field_two'=($a)]
>> [/inline]
>>
>> Thanks in advance for any help
>>
>> francesco
>>
>>
>>
>>
>> #############################################################
>> This message is sent to you because you are subscribed to
>> the mailing list Lasso Lasso@lists.lassosoft.com
>> Official list archives available at http://www.lassotalk.com
>> To unsubscribe, E-mail to: <Lasso-unsubscribe@lists.lassosoft.com>
>> Send administrative queries to <Lasso-request@lists.lassosoft.com>
>
> #############################################################
> This message is sent to you because you are subscribed to
> the mailing list Lasso Lasso@lists.lassosoft.com
> Official list archives available at http://www.lassotalk.com
> To unsubscribe, E-mail to: <Lasso-unsubscribe@lists.lassosoft.com>
> Send administrative queries to <Lasso-request@lists.lassosoft.com>
#############################################################
This message is sent to you because you are subscribed to
the mailing list Lasso Lasso@lists.lassosoft.com
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <Lasso-unsubscribe@lists.lassosoft.com>
Send administrative queries to <Lasso-request@lists.lassosoft.com>
Jun 04, 2014; 08:26
Jonathan Guthrie
Re: Cyrillic text in MySql DB table
Jun 04, 2014; 06:31
Tim Taplin
Re: Cyrillic text in MySql DB table