Hi All,
I downloaded Sequel Pro (thanks Tim), I found out that in Sequel Pro and PhpMyAdmin the cyrillic chars display correctly.
On Navicat I just get question marks…
Now the problem is when I print to PDF, here is some code from the page (BOM ok!):
"…….
[Var: 'Font_06'=(PDF_Font: -Face='helvetica', -Size=9, -Encoding='utf8')]
…….
[inline: -database='DB', -table='table', -keyfield='ID', -search, -maxrecords='all', 'ID_cliente'=($ID_cliente)]
[var: 'posizione_top' = '235']
[records]
[var: 'cyrillic_text' = (field: 'field_two')]
[$pdfvoucher->(DrawText: $cyrillic_text, -Font=$Font_06, -Left=45.0, -Top=$posizione_top)]
[var: 'posizione_top' = (math_add: (Integer: ($posizione_top)), 15)]
[/records]
[/inline]"
but I get only:
"(FCO) , 1-3 pax, , Van/Sedan"
with no cyrillic chars.
Is there something I am missing?
Thanks again
francesco
Il giorno 04/giu/2014, alle ore 14:31, Tim Taplin ha scritto:
> I took your text and pasted into a testing mysql table that was on my server, it appears to display fine. In looking for possible explanations, I'm thinking that you should double check the structure for possible field or column level encoding settings
>
> In sequel pro, when I look at the table structure, it will show me the encoding on a per column basis and allow for that default encoding to be overwritten. I cant think of a reason that this would happen without some specific intentional change being made, but its worth taking a look at on your table.
>
> Tim Taplin
>
> On Jun 4, 2014, at 6:13 AM, Francesco Badaloni <f.badaloni@graffitinet.it> wrote:
>
>> 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>
>
> #############################################################
> 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>