#1  
Old 25th June 2013, 02:54 AM
Micael Micael is offline
Member
 
Join Date: Mar 2011
Posts: 78
Default International character problem

Working with HTML5 Builder
Have a database connected to NexusDB
have a textfield that in enterpricemanager says ÅÄÖ
when getting the same field with a Query it shows like ÅÄÖ

What to do
  #2  
Old 28th June 2013, 05:26 AM
Alexander Telegin [NDX]
 
Posts: n/a
Default Re: International character problem

Micael,

Try to use WideString field type instead of Shortstring.

Regards,
Alex

On 6/24/2013 6:54 PM, Micael wrote:
> Working with HTML5 Builder
> Have a database connected to NexusDB
> have a textfield that in enterpricemanager says едж
> when getting the same field with a Query it shows like Ñ*┘Ñ*â””Ñ*√
>
> What to do
>
>


  #3  
Old 28th June 2013, 07:36 PM
Micael Micael is offline
Member
 
Join Date: Mar 2011
Posts: 78
Default

Changed to Widestring but still the same problem.
I also made a little testprogram with the same codebase where one side is working with the NexusDB and the other works with mySQL to control the settings on the page . The mySQL works fine but the NexusDB has this problem

micael

Quote:
Originally Posted by Alexander Telegin [NDX] View Post
Micael,

Try to use WideString field type instead of Shortstring.

Regards,
Alex

On 6/24/2013 6:54 PM, Micael wrote:
> Working with HTML5 Builder
> Have a database connected to NexusDB
> have a textfield that in enterpricemanager says едж
> when getting the same field with a Query it shows like Ñ*┘Ñ*â””Ñ*√
>
> What to do
>
>
  #4  
Old 28th June 2013, 11:17 PM
Alexander Telegin [NDX]
 
Posts: n/a
Default Re: International character problem

What PHP version do you use?


On 6/28/2013 11:36 AM, Micael wrote:
> Changed to Widestring but still the same problem.
> I also made a little testprogram with the same codebase where one side
> is working with the NexusDB and the other works with mySQL to control
> the settings on the page . The mySQL works fine but the NexusDB has this
> problem
>
> micael
>
> 'Alexander Telegin [NDX Wrote:
>> ;98066']Micael,
>>
>> Try to use WideString field type instead of Shortstring.
>>
>> Regards,
>> Alex
>>
>> On 6/24/2013 6:54 PM, Micael wrote:
>>> Working with HTML5 Builder
>>> Have a database connected to NexusDB
>>> have a textfield that in enterpricemanager says аЕаДаЖ
>>> when getting the same field with a Query it shows like

>> бÂ*т”˜бÂ*т””РÂ*тˆš
>>>
>>> What to do
>>>
>>>

>
>


  #5  
Old 29th June 2013, 08:15 AM
Micael Micael is offline
Member
 
Join Date: Mar 2011
Posts: 78
Default

5.3
micael

Quote:
Originally Posted by Alexander Telegin [NDX] View Post
What PHP version do you use?


On 6/28/2013 11:36 AM, Micael wrote:
> Changed to Widestring but still the same problem.
> I also made a little testprogram with the same codebase where one side
> is working with the NexusDB and the other works with mySQL to control
> the settings on the page . The mySQL works fine but the NexusDB has this
> problem
>
> micael
>
> 'Alexander Telegin [NDX Wrote:
>> ;98066']Micael,
>>
>> Try to use WideString field type instead of Shortstring.
>>
>> Regards,
>> Alex
>>
>> On 6/24/2013 6:54 PM, Micael wrote:
>>> Working with HTML5 Builder
>>> Have a database connected to NexusDB
>>> have a textfield that in enterpricemanager says аЕаДаЖ
>>> when getting the same field with a Query it shows like

>> бÂ*т”˜бÂ*т””РÂ*тˆš
>>>
>>> What to do
>>>
>>>

>
>
  #6  
Old 30th June 2013, 12:16 AM
Alexander Telegin [NDX]
 
Posts: n/a
Default Re: International character problem

Micael, I sent you deployed version that works fine, at least, with
Cyrillic charset. Please test and let me know.

On 6/29/2013 12:15 AM, Micael wrote:
> 5.3
> micael
>
> 'Alexander Telegin [NDX Wrote:
>> ;98073']What PHP version do you use?
>>
>>
>> On 6/28/2013 11:36 AM, Micael wrote:
>>> Changed to Widestring but still the same problem.
>>> I also made a little testprogram with the same codebase where one

>> side
>>> is working with the NexusDB and the other works with mySQL to control
>>> the settings on the page . The mySQL works fine but the NexusDB has

>> this
>>> problem
>>>
>>> micael
>>>
>>> 'Alexander Telegin [NDX Wrote:
>>>> ;98066']Micael,
>>>>
>>>> Try to use WideString field type instead of Shortstring.
>>>>
>>>> Regards,
>>>> Alex
>>>>
>>>> On 6/24/2013 6:54 PM, Micael wrote:
>>>>> Working with HTML5 Builder
>>>>> Have a database connected to NexusDB
>>>>> have a textfield that in enterpricemanager says аАа•аАа”аАаÂ
>>>>> when getting the same field with a Query it shows like
>>>> аБТÂ*б‚Т”Т˜аР‘ТÂ*б‚Т”Т”аБР¢Â*б‚ТˆТš
>>>>>
>>>>> What to do
>>>>>
>>>>>
>>>
>>>

>
>


  #7  
Old 2nd July 2013, 05:02 AM
Micael Micael is offline
Member
 
Join Date: Mar 2011
Posts: 78
Default

Thank You for all Your efforts
I run XAMPP 1.7.7 with php 5.3.8 and then it works

Still when trying from within HTML5 Builder the problem remains

micael


Quote:
Originally Posted by Alexander Telegin [NDX] View Post
Micael, I sent you deployed version that works fine, at least, with
Cyrillic charset. Please test and let me know.

On 6/29/2013 12:15 AM, Micael wrote:
> 5.3
> micael
>
> 'Alexander Telegin [NDX Wrote:
>> ;98073']What PHP version do you use?
>>
>>
>> On 6/28/2013 11:36 AM, Micael wrote:
>>> Changed to Widestring but still the same problem.
>>> I also made a little testprogram with the same codebase where one

>> side
>>> is working with the NexusDB and the other works with mySQL to control
>>> the settings on the page . The mySQL works fine but the NexusDB has

>> this
>>> problem
>>>
>>> micael
>>>
>>> 'Alexander Telegin [NDX Wrote:
>>>> ;98066']Micael,
>>>>
>>>> Try to use WideString field type instead of Shortstring.
>>>>
>>>> Regards,
>>>> Alex
>>>>
>>>> On 6/24/2013 6:54 PM, Micael wrote:
>>>>> Working with HTML5 Builder
>>>>> Have a database connected to NexusDB
>>>>> have a textfield that in enterpricemanager says аАа•аАа”аАаÂ
>>>>> when getting the same field with a Query it shows like
>>>> аБТÂ*б‚Т”Т˜аР‘ТÂ*б‚Т”Т”аБР¢Â*б‚ТˆТš
>>>>>
>>>>> What to do
>>>>>
>>>>>
>>>
>>>

>
>
  #8  
Old 2nd July 2013, 06:11 AM
Alexander Telegin [NDX]
 
Posts: n/a
Default Re: International character problem

Did you put

ini_set('default_charset', 'utf-8');

at top of your page?


On 7/1/2013 9:02 PM, Micael wrote:
> Thank You for all Your efforts
> I run XAMPP 1.7.7 with php 5.3.8 and then it works
>
> Still when trying from within HTML5 Builder the problem remains
>
> micael
>
>
> 'Alexander Telegin [NDX Wrote:
>> ;98084']Micael, I sent you deployed version that works fine, at least,
>> with
>> Cyrillic charset. Please test and let me know.
>>
>> On 6/29/2013 12:15 AM, Micael wrote:
>>> 5.3
>>> micael
>>>
>>> 'Alexander Telegin [NDX Wrote:
>>>> ;98073']What PHP version do you use?
>>>>
>>>>
>>>> On 6/28/2013 11:36 AM, Micael wrote:
>>>>> Changed to Widestring but still the same problem.
>>>>> I also made a little testprogram with the same codebase where one
>>>> side
>>>>> is working with the NexusDB and the other works with mySQL to

>> control
>>>>> the settings on the page . The mySQL works fine but the NexusDB has
>>>> this
>>>>> problem
>>>>>
>>>>> micael
>>>>>
>>>>> 'Alexander Telegin [NDX Wrote:
>>>>>> ;98066']Micael,
>>>>>>
>>>>>> Try to use WideString field type instead of Shortstring.
>>>>>>
>>>>>> Regards,
>>>>>> Alex
>>>>>>
>>>>>> On 6/24/2013 6:54 PM, Micael wrote:
>>>>>>> Working with HTML5 Builder
>>>>>>> Have a database connected to NexusDB
>>>>>>> have a textfield that in enterpricemanager says

>> аАааАТ•аАа °ÐÐ¢Â”аАааАТ–
>>>>>>> when getting the same field with a Query it shows like
>>>>>> аАа‘аЂТÂ*аБТ ‚аЂТ”аЂТ˜аАа ‘аЂТÂ*аБТ‚аЂ Т”аЂТ”аАа‘аР‚ТÂ*аБТ‚аЂТˆРЂТš
>>>>>>>
>>>>>>> What to do
>>>>>>>
>>>>>>>
>>>>>
>>>>>
>>>
>>>

>
>


  #9  
Old 2nd July 2013, 07:06 PM
Micael Micael is offline
Member
 
Join Date: Mar 2011
Posts: 78
Default

Perfect now everything works fine
Maybe HTML5 Builder should put that line when You choose Encoding for a page

Thanks again for all
micael

Quote:
Originally Posted by Alexander Telegin [NDX] View Post
Did you put

ini_set('default_charset', 'utf-8');

at top of your page?


On 7/1/2013 9:02 PM, Micael wrote:
> Thank You for all Your efforts
> I run XAMPP 1.7.7 with php 5.3.8 and then it works
>
> Still when trying from within HTML5 Builder the problem remains
>
> micael
>
>
> 'Alexander Telegin [NDX Wrote:
>> ;98084']Micael, I sent you deployed version that works fine, at least,
>> with
>> Cyrillic charset. Please test and let me know.
>>
>> On 6/29/2013 12:15 AM, Micael wrote:
>>> 5.3
>>> micael
>>>
>>> 'Alexander Telegin [NDX Wrote:
>>>> ;98073']What PHP version do you use?
>>>>
>>>>
>>>> On 6/28/2013 11:36 AM, Micael wrote:
>>>>> Changed to Widestring but still the same problem.
>>>>> I also made a little testprogram with the same codebase where one
>>>> side
>>>>> is working with the NexusDB and the other works with mySQL to

>> control
>>>>> the settings on the page . The mySQL works fine but the NexusDB has
>>>> this
>>>>> problem
>>>>>
>>>>> micael
>>>>>
>>>>> 'Alexander Telegin [NDX Wrote:
>>>>>> ;98066']Micael,
>>>>>>
>>>>>> Try to use WideString field type instead of Shortstring.
>>>>>>
>>>>>> Regards,
>>>>>> Alex
>>>>>>
>>>>>> On 6/24/2013 6:54 PM, Micael wrote:
>>>>>>> Working with HTML5 Builder
>>>>>>> Have a database connected to NexusDB
>>>>>>> have a textfield that in enterpricemanager says

>> аАааАТ•аАа °ÐÐ¢Â”аАааАТ–
>>>>>>> when getting the same field with a Query it shows like
>>>>>> аАа‘аЂТÂ*аБТ ‚аЂТ”аЂТ˜аАа ‘аЂТÂ*аБТ‚аЂ Т”аЂТ”аАа‘аР‚ТÂ*аБТ‚аЂТˆРЂТš
>>>>>>>
>>>>>>> What to do
>>>>>>>
>>>>>>>
>>>>>
>>>>>
>>>
>>>

>
>
  #10  
Old 3rd July 2013, 02:35 AM
Micael Micael is offline
Member
 
Join Date: Mar 2011
Posts: 78
Default

I was too quick to be happy

the added line
ini_set('default_charset', 'utf-8');
Made everything from the database OK but all other text got the problem instead

micael


Quote:
Originally Posted by Micael View Post
Perfect now everything works fine
Maybe HTML5 Builder should put that line when You choose Encoding for a page

Thanks again for all
micael


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Ordinal value of a character Gerard Hook nexusdb.public.support.sql 1 12th May 2008 02:44 PM
Blaise Pascal - international magazine about Delphi and Pascal Eivind Bakkestuen [NDD] nexusdb.public.support.thirdparty 7 23rd April 2008 01:51 PM
Tax in international invoice system Chris nexusdb.public.discussions 11 28th June 2006 07:16 PM
character set vs. collation Thomas Lohrum nexusdb.public.support 0 21st July 2005 08:12 AM
International sort order Chris de Gelder nexusdb.public.support 1 12th May 2005 09:53 PM


All times are GMT +11. The time now is 06:44 PM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.