0
Welcome Guest! Login
0 items Join Now

MySQL database collation

  • MySQL database collation

    Posted 12 years 2 weeks ago
    • Hi

      i wanna set up a new website with the latest alerion april 2013 template running on joomla 3.0.3. and i download the package wich contains the latest version of Joomla 3 install as well as the alerion template and demo sample content. after uploading this stuff to my srv i set my database collation to "greek_general_ci".

      After finishing the joomla installation i always fount a mix of diferent collations from swedisch and uni general and stuff like that. Only the greek fonts DONT work and as a result i read only letters like this: "???? ????_?? ??"

      iIs there a way to install the rt alerion with the sample data in the collation i want or not?

      MySQL
      Server: Localhost via UNIX socket
      Server version: 5.1.63-0+squeeze1
      Protocol version: 10
      MySQL charset: UTF-8 Unicode (utf8)

      Web server
      Apache
      MySQL client version: 5.1.63
      PHP extension: mysql

      phpMyAdmin

      Version information: 3.3.7deb7
    • ΖΝ ΣΧΟΛΗ ΠΑΛΙΟΚΑΡΙΟΛΗ Α!
    • Who?'s Avatar
    • Who?
    • Preeminent Rocketeer
    • Posts: 25562
    • Thanks: 613
    • Joomla freelancer

    Re: MySQL database collation

    Posted 12 years 1 week ago
    • It should be possible but you will have to edit sample sql files and change collations (or set them if they don't exist) in files directly
    • Check my services at: Mihha-Vision
  • Re: MySQL database collation

    Posted 12 years 1 week ago
    • this means that there is NOT a way to install the rt sample data in the collation i want. i m not goin to do this manualy with hand for each table..
    • ΖΝ ΣΧΟΛΗ ΠΑΛΙΟΚΑΡΙΟΛΗ Α!
    • Who?'s Avatar
    • Who?
    • Preeminent Rocketeer
    • Posts: 25562
    • Thanks: 613
    • Joomla freelancer

    Re: MySQL database collation

    Posted 12 years 1 week ago
    • You don't have to do this manually. Just open SQL files in some text editor and then it is just a matter of search and replace
    • Check my services at: Mihha-Vision

Time to create page: 0.081 seconds