Your problem 1) is strange for a clean install. Could you check:
- what page encoding your browser detects
- what database encoding is really used and
- what table encoding is used for the videodata table?
On 02.11.2008 16:54, yourmatebox@... wrote:
> Thanks for your reply!
> I've done the conversion (all tables one by one) using command: "alter
> table actors(etc) CONVERT TO CHARACTER SET utf8;" within phpmyadmin as
> I did not see any "detailed steps printed by videodb installer" (do
> you mean when running the install.php?!?)
> But this might be my ignorance, however I've read the FAQ, readme and
> install in /doc...
> My problems are:
> 1.) after making a fresh install (not using my old database) I am not
> able to use accented characters in title and plot because the text
> will be cut off and deleted from the first accented char
> 2.) even if I could use accented chars in the new database I would be
> required to reenter my 300+ movies unless I can convert it somehow
>
> Could you direct me to any howto as all I've found is obsolete because
> of changed code in new version
> Thanks
>
> ------------------------------------------------------------------------
> *From:* Andreas Goetz [mailto:cpuidle@...]
> *Sent:* Sunday, November 02, 2008 1:18 PM
> *To:* videodb-devel@...
> *Subject:* Re: [videodb-devel] character set problem in new version
>
> I'm not sure what your problem is. If you use the videodb
> installer it prints detailed steps to follow (i.e. db commands to
> run) to convert your db to utf-8. Did you follow these?
>
> On 31.10.2008 14:53, yourmatebox@... wrote:
>> Hello,
>> I'd like some support on accented characters in videoDB
>> I used to use videoDB quite happily on my Qnap TS-101 NAS approx.
>> for two years and I have around 400 records in my database.
>> Recently I have decided to install the new version (3.0.2) under
>> my public domain to make it available to my friends as well.
>> However I'm NOT quite a linux & mysql professional I've sorted
>> out most of the problems I faced during installing videodb
>> (request mods from my provider; config.inc.php missing @ install;
>> convert the old database to the new structure; etc) - so now
>> videoDB 3.0.2 is running on my public domain.
>> However I cannot resolve my character issue no matter how hard I
>> tried...
>> My OLD videodb on my NAS used a latin1_swedish_ci charset (why
>> swedish I do not know, it just happened to be)
>> In videodb I DO need accented charset as I have many of those
>> titles among my movies.
>> On my public domain my database is utf8 and it cuts of accented
>> characters.
>> I came accross this thread
>> <http://osdir.com/ml/video.videodb.devel/2006-10/msg00029.html>
>> and tried it and successfully converted my database but I
>> couldn't make "VideoDb connect in latin1" as the code in
>> core/functions.php has changed :)
>> I also converted my old database to utf8 - just to try if I'll be
>> lucky - but this did not solve the problem either.
>> What I'd like to have is:
>> use the mysql database in utf8 (as provided by my isp) and use
>> accented characters in my titles WITHOUT - if possible -
>> reentering all 350 movie entries to videoDB as movie PLOTs
>> contains many accented characters as well...
>> Thanks for your support,
>> yourmate
>> ------------------------------------------------------------------------
>>
>> -------------------------------------------------------------------------
>> This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
>> Build the coolest Linux based applications with Moblin SDK& win great prizes
>> Grand prize is a trip for two to an Open Source event anywhere in the world
>> http://moblin-contest.org/redirect.php?banner_id=100&url=/
>> ------------------------------------------------------------------------
>>
>> _______________________________________________
>> videodb-devel mailing list
>> videodb-devel@...
>> https://lists.sourceforge.net/lists/listinfo/videodb-devel
>>
>
> ------------------------------------------------------------------------
>
> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
> Build the coolest Linux based applications with Moblin SDK& win great prizes
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> ------------------------------------------------------------------------
>
> _______________________________________________
> videodb-devel mailing list
> videodb-devel@...
> https://lists.sourceforge.net/lists/listinfo/videodb-devel
>
|