Character set problem

[Mester József]

Hy
  
  I have a table datas like that : 
  name 
  Mester József
  Job György
  Czibere Lajos
  
  If I create :
  
  select name from dolgozok where name like '%jó%' ;
  
  then all data will be shown.
  But I wolud like see datas which really contain ó character (only Mester 
József).
  
  Joe
  
  

-
Win a BlackBerry device from O2 with Yahoo!. Enter now.

DATE problem

[Mester József]

Hy all
  
  I would like to get date in my web page.
  There are three different fields. YEAR MONTH and DAY
  I thought in SQL possible create table like this /*from my book*/
  
  create table dates ( input_year DATETIME YEAR TO YEAR, 
input_month  DATETIME MONTH TO MONTH,
input_day  DATETIME DAY TO DAY);
  
  In this example I can store year,month and day values in different fields.
  Mysql doesn't accept this create statement.
  
  Joe
  
  


-
Yahoo! Messenger  NEW - crystal clear PC to PC calling worldwide with voicemail 

SQL Question

[Mester József]

Hy
  
  I want to sum quantites but there is some data that value is negative  but 
users didn't write the - sign before. I can decide which datas are  negative.
  
  I would like something like that 
  
  select sum(moved_quantities) from db
  if moving like 'Move-' then sum seem the move is negative
  else move value is positive
  
  Is it possible?
  
  Joe
  
  


-
  Yahoo! Cars NEW - sell your car and browse thousands of new and used cars 
online search now  
-
  

Re: SQL Question

[Mester József]

Hy

If you know which values are supposed to be negative, wouldn't it be 
easier to do updates to your data to change all of those values to 
negatives? That should only need to be done once. Then use the normal 
SQL sum() function to add all of the values together.


Thank you. Actually my first thing was update but my SQL knowledge is 
weak and I don't want to mess the database.
I started a script which is update bad records on a copy of that 
database. However I didn't solve the update problem.


My script is in (PL/SQL):

integer a;
integer b;
varchar tr;
varchar ra;
varchar ke;
varchar moti;

begin

select tm.tr,tm.ra,tm.ke,tm.moti,tm.mome
into tr,ke,moti,a
from ev98nv_tm tm
where MOTI like 'Rakt.kozi-' or MOTI like 'Kiadas -'
and tm.EV like '2005'

if (a 0) then
a=b;
b = 0- b;
update ev98nv_tm set mome=b where tm.tr=tr and tm.ra=ra and tm.ke=ke and 
tm.moti=moti ;


end;

But it is not working. The Primary index is tr+ra+ke+moti


Rhino






___ 
Yahoo! Messenger - NEW crystal clear PC to PC calling worldwide with voicemail http://uk.messenger.yahoo.com



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Php is not working with MySQL

[Mester József]

Hy 
  
 I installed a Debian Sarge. Everything worked but I needed newer verison  
 of mysql (4.1.11) and since I installed newer MySQL (from deb package)  
 the php is not working with mysql. 
  
 Please help. 
 
 Joe
  
 


-
  Win a Yahoo! Vespa NEW - Yahoo! Cars has 3 Vespa LX125s to be won Enter Now! 

Setting charset

[Mester József]

For Archivum  
 
 My destination was: Changing default latin1 charset to latin2 and the default 
collation to latin2_hungarian_ci.
 
 I tried to configure accross my.cnf, but all of my effort failed.
 
 I installed mysql-administrator, use startup paramters in. Change mysqldump . 
Took changes and it works.
 
 Joe
 
 
 
 


-
 Yahoo! Model Search  - Could you be the next catwalk superstar? Check out the 
competition now 

default character setting

[Mester József]

Hy
 
 I tried to set the default character set for mysql-4.1-15 server in my.cnf
 [client] section
 with set :
 character-sets-dir=/usr/local/mysql/share/mysql/charsets
 and 
 default_character_set=latin2
 
 but when I check the defaults by show variables like '%_server' 
 I get these value is latin1
 
 What is wrong? 
 
 Please help.
 
 Joe
 
 
 


-
 Yahoo! Model Search  - Could you be the next catwalk superstar? Check out the 
competition now