convert query

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
rodrigorules
Forum Commoner
Posts: 35
Joined: Wed Jan 05, 2005 3:10 pm

convert query

Post by rodrigorules »

when i try to run this it says i must convert it..
how do i convert it.. =/

UPDATE Character SET Inventory = '0xFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

is there a reason you are using a number value that large?

maybe removing the quotes.
rodrigorules
Forum Commoner
Posts: 35
Joined: Wed Jan 05, 2005 3:10 pm

Post by rodrigorules »

yea i found out how...remove qoutes and use CAST

yea its for a gameserver..SQL holds all the game info
i wanted to delete everyones items( F's stands for empty)
Post Reply