close ad
Install the LAtest Updates to Work with CC 2017 and CC 2018
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Polish characters in data table replaced by numerical code

Thread began 5/30/2013 9:37 am by Roxana | Last modified 5/30/2013 12:15 pm by Roxana | 229 views | 2 replies |

Roxana

Polish characters in data table replaced by numerical code

Hi,

I added Polish to the list of languages for our internet shop. For data entry, I used pages generated with DataAssist. The charset is set to ISO-8859-1.

All Polish special characters were automatically converted into numerical code, and the display on the webpages converted back to Polish characters again. So far that's good.

However, when I export the database tables into Excel or OpenOffice, the numerical code is not converted back into legible Polish characters. I need this done though, because the translator has to correct the entries.

My attempt at a solution was to enter data as Polish characters (not numerical code). Export works fine then, but I have not been able to display the characters properly on the webpage. I then changed the coalition to utf8_general_ci both on the webpage and the data table, but still the Polish characters are not displayed correctly.

Are there any settings I can use to display Polish characters when they are not entered into the database as numerical code?

Or is there a way to export tables with numerical code, that will convert into characters?

Thank you for any help :)


Update: I learned that ISO 8859-1 does not include polish, but ISO 8859-2 does. I can't use two different charsets on the same page though, or can I? Would that mean there is no way around the numerical code?

Sign in to reply to this post

Jason ByrnesWebAssist

Use Dynamic Connections for the database connection.

In Dynamic Connections, you can select the character set to be used by the connection, set it to the UTF 8 character set.

also use the UTF 8 character set on your pages.

Sign in to reply to this post

Roxana

Jason, that worked like a charm. Thank you sooo much.

I changed the data entry pages as well, and just by updating each product, the numerical code is replaced. That is better than doing the data entry all over again.

Thanks :)

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...