Home News Contact Us Forum About Us Demos Products F.A.Q.
Shopping Cart
You currently have 0 items in your cart.


Recent Events
  • 31/12/2023 New Year SALE

    We are glad to announce New Year SALE. 25% discount for all our extensions. Use NY24 coupon code. Hurry up the discount is valid till 7 January.

  • 21/11/2023 BLACK FRIDAY 23 is coming

    BIG SALE, 35% discount for all our extensions. Use BF23 coupon code. Hurry up the discount is valid till 27 November.


2Checkout.com, Inc. is an authorized retailer of goods and services provided by ARI Soft. 2CheckOut




Follow us on twitter



Welcome, Guest
Please Login or Register.    Lost Password?

[SOLVED] Accented characters in ARI Data Tables
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: [SOLVED] Accented characters in ARI Data Tables
#17454
[SOLVED] Accented characters in ARI Data Tables 12 Years, 8 Months ago Karma: 0
Hi there,

First of all, I want to thank you for a terrific product. I was able to create a database and insert a table onto my Joomla website with surprising ease. I was also very pleasantly surprised to see it accomodated my variable width template straight away as well! ^_^

I am having ONE problem, however ...

Many of the characters in my data are accented (for example: и) - but these do not show up correctly. Do you have any immediate ideas as to how I can fix this?

Thanks in advance.

(LEFT: ARI Data Tables output / RIGHT: Correct text as it appears in the database)
Last Edit: 2011/07/18 21:39 By RedRabbit.Reason: added 'solved' to the title
The administrator has disabled public write access.
 
#17457
Re:Accented characters in ARI Data Tables 12 Years, 8 Months ago Karma: 746
Hello,

If data is shown from a CSV file and saved in non-UTF8 encoding, set appropriate encoding in "CSV -> File encoding" parameter or save CSV file in UTF-8 encoding.

Regards,
ARI Soft
The administrator has disabled public write access.
 
#17487
Re:Accented characters in ARI Data Tables 12 Years, 8 Months ago Karma: 0
Hi there - thanks for the quick response.

Sadly, it's not quite as simple as that. I'm not pulling the data from CSV files - I'm using a separate MySQL database which contains all my data. The database stores everything in utf8-unicode-ci, so I think that should be good ... but I don't know what's happening between there and the output to the site ...
The administrator has disabled public write access.
 
#17488
Re:Accented characters in ARI Data Tables 12 Years, 8 Months ago Karma: 746
Set "SQL -> External Database -> Charset name" parameter to UTF8 value.

Regards,
ARI Soft
The administrator has disabled public write access.
 
#17494
Re:Accented characters in ARI Data Tables 12 Years, 8 Months ago Karma: 0
Brilliant. That did the trick - thanks so much.

(I already tried 'utf8-unicode-ci', and didn't think to try UTF8! *doh!*)
The administrator has disabled public write access.
 
Go to topPage: 1