Update with select

pdata' for update in FROM clause What can I use to fix this? | -- Albert E. Whale, CHS CISA CISSP Sr. Security, Network, Risk Assessment and Systems Consultant ABS Computer Technology, Inc. <http://www.ABS-CompTech.com&g

How do I change the Collation Variables?

How do I change: | collation_connection| latin1_swedish_ci | | collation_database | latin1_swedish_ci | | collation_server| latin1_swedish_ci to latin1_bin? Is this in my.cnf? or is this another way to do this? -- Albert E. Whale, CHS CISA CISSP Sr