Go Back   EQEmulator Home > EQEmulator Forums > Development > Development::Bots

Development::Bots Forum for bots.

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 08-02-2011, 12:39 PM
mamba700
Fire Beetle
 
Join Date: Oct 2010
Posts: 5
Default Fix View

OK I have it fixed now and runs fine.

Here is what needs to be done. The operation of UNION ALL requires that the fields are the same character set.

So check bots and character_ tables. Look in each field for the character set. Change the set to match the other table.

So Specifically i looked at 'Name' in table character_ and it shows character set = latin1 collation = latin1_swedish_ci

So I then go to the same field in table bots and change it to match. Once this was done the view was created with no errors.

I hope this helps other folks with the same problem.
Reply With Quote
 


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 08:58 AM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3