Recent content by Dabase

Hi, I need to set up a site with live TV and was wondering how to go about setting this up. I would really appreciate it if someone could point me in the right direction. Thanks Dabase

I found some useful info: This shows the list of character sets currently supported by your version of MySQL: SHOW CHARACTER SET; This alters the database, but does not alter existing tables, only tables created after this alter statement will take greek encoding into effect: ALTER DATABASE...

Hi, After some research on the net, I have gathered that the most probable cause is due to encoding. But I am concerned that if I change the encoding to greek, the database will then stop recognising the english alphabet, is this going to be the case? Thanks Dabase

Now I am baffled, because after adding the ';', the query ran with no errors [neutral] Thanks Dabase

Hi, Apologies for the previous thread, it is converting the greek letter 'miu' into ì Thanks Dabase

Hi, My MySQL seems to be converting ? to ì, any ideas why this is happening? MySQL version: 4.1 Thanks Dabase

The problem was that I was missing a ";" at the end Thanks Dabase

No because "AS" is optional Thanks Dabase

Hi mbrooks, Are you saying that it is fishy because of the way that the alias has been defined. That is usually how I define tables aliases, is there a better way to do it? Thanks Dabase

Hi, There was a ';' missing at the end so that the statement looks like: CREATE TABLE `criteria` ( select PGC.PGC_P_ID, P_Title, GROUP_CONCAT(A_ID,'|', C_Title) AS Criteria from tblproductsgroupcriteria PGC join tblproducts P on PGC_P_ID = P_ID join tblproductsgroupindustry PGI on...

misterjoe, Thanks for the response. The encoding is SQL_ASCII /usr/local/pgsql/bin/createdb -E SQL_ASCII test I did manage to connect to the server from PGAdmin installed on another machine and saw that it was picking the accents, etc... so a star for ceco I will try to use rpm --no-deps...

Hi, I am trying to create a table as follows: CREATE TABLE `criteria` ( select PGC.PGC_P_ID, P_Title, GROUP_CONCAT(A_ID,'|', C_Title) AS Criteria from tblproductsgroupcriteria PGC join tblproducts P on PGC_P_ID = P_ID join tblproductsgroupindustry PGI on PGInd_P_ID = P_ID join tblcriteria...

Hi ceco, Once again, thanks for the response. I have done the following: ... /usr/local/pgsql/bin/initdb --locale=pt_PT -D /usr/local/pgsql/data ... /usr/local/pgsql/bin/createdb -E SQL_ASCII test When I performed the restore I did not get the errors I was experiencing before. However...

Hi ceco, Thanks for the reply. After I installed Postgres, I tried to restore a database that contains characters with accents and I got some errors. Could you please advise me on where I can find information on encoding. My understanding of clustering is having more than one server, which is...

Hi, During or after installation of PostgreSQL 8 on FC4, is there a configuration option or an add-on that handles accents for the Portuguese languange? Thanks Dabase