CodeCharge Studio
search Register Login  

Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> PHP

 MySQL query does not work with special character fields outside CCS

Print topic Send  topic

Author Message
gbolz

Posts: 13
Posted: 11/27/2011, 6:57 AM

Hi,

I am developing a redesign of an 20 years old German paradox application. A lot of tables have fields including (German) special characters. I cannot change this special characters as I have a lot of users with the old paradox application and therefore the database has to be compatible.

So far there have been no problems with this special charcater fields in all of the direct CCS pages. All works fine. But now I have to produce an external php library with often used functions.
When I run these external functions, all the queries fail cause of this special character fields.
When I put the query in a appropriate CCS *_events.php area it works!

What do I wrong?

Thanks for help.

Gerhard
View profile  Send private message
mamboBROWN


Posts: 1713
Posted: 12/10/2011, 4:06 PM

gbolz,

Have you been able to resolve this issue yet?
View profile  Send private message
gbolz

Posts: 13
Posted: 12/11/2011, 4:51 AM

No, I could not solve the problem up to now. Perhaps you have any idea?
Thank you for any hint.

Gerhard
View profile  Send private message
andy


Posts: 183
Posted: 12/15/2011, 5:15 AM

Have you checked the encoding of your database?
Windows 1252 should cover German characters, I think.
If in doubt you can always use utf8

You may also need to specify the locale settings under project settings.

Does your ccs app use autofill or other AJAX routines?
If so, WIndows 1252 seems to be the most versatile encoding.
_________________
Andy

RAD tools for rich UI controls:
http://www.koolphptools.com
View profile  Send private message
gbolz

Posts: 13
Posted: 01/12/2012, 2:49 AM

andy, thanks for your answer.
Meanwhile I have resolved the issue .
CCS changes all special characters when generating the page files on the server, leaving the original characters in the source.
With this new created special charaters all works perfect.
All other code pages (libraries) , which do not belong directly to the CCS page, are not translated.
Cause of that I have all the problems.
As workaround I use in my libraries the same characters like created by CCS.
Now it works.
Perhaps you have any better idea?
The character set of the complete CCS project is utf8.

Thank you.

Gerhard

View profile  Send private message

Add new topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Web Database

Join thousands of Web developers who build Web applications with minimal coding.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.