Hibernate operation: could not execute query; uncategorized SQLException for SQL [select this_.ID as ID8_0_, this_.ADDRESS as ADDRESS8_0_, this_.DESCRIPTION as DESCRIPT3_8_0_, this_.DISABLED as DISABLED8_0_, this_.EMAIL as EMAIL8_0_, this_.FAX as FAX8_0_, this_.NAME as NAME8_0_, this_.NO_OF_ROOMS as NO8_8_0_, this_.TELEPHONE as TELEPHONE8_0_, this_.RATING as RATING8_0_, this_.WEBSITE as WEBSITE8_0_, this_.FB_NAME as FB12_8_0_, this_.TRIPADVISOR_ID as TRIPADV13_8_0_, this_.TRIPADVISOR_PARTNER_ID as TRIPADV14_8_0_, this_.ZIPCODE as ZIPCODE8_0_, this_.PREFIX as PREFIX8_0_, this_.AUTO_CLOSE as AUTO17_8_0_, this_.DEFAULT_SHOWING_GUEST as DEFAULT18_8_0_, this_.DEFAULT_NIGHTS as DEFAULT19_8_0_, this_.ORDER_OPTION as ORDER20_8_0_, this_.ORDER_DIRECTION as ORDER21_8_0_, this_.SEARCH_TREATMENT as SEARCH22_8_0_, this_.PERCENT_PAYMENT as PERCENT23_8_0_, this_.COMMISSION as COMMISSION8_0_, this_.PROMOTION_POINT as PROMOTION25_8_0_, this_.GATEWAY as GATEWAY8_0_, this_.GATEWAY_REF_NO_1 as GATEWAY27_8_0_, this_.GATEWAY_REF_NO_2 as GATEWAY28_8_0_, this_.GATEWAY_REF_NO_3 as GATEWAY29_8_0_, this_.GATEWAY_REF_NO_4 as GATEWAY30_8_0_, this_.GATEWAY_REF_NO_5 as GATEWAY31_8_0_, this_.BN_CODE as BN32_8_0_, this_.GATEWAY_URL as GATEWAY33_8_0_, this_.CREATED_DATE as CREATED34_8_0_, this_.UPDATED_DATE as UPDATED35_8_0_, this_.CREATED_BY as CREATED36_8_0_, this_.UPDATED_BY as UPDATED37_8_0_, this_.PUBLIC_KEY as PUBLIC38_8_0_, this_.CUSTOM_PAYMENT_GATEWAY as CUSTOM39_8_0_, this_.CURRENCY as CURRENCY8_0_, this_.LANGUAGE as LANGUAGE8_0_, this_.SEO_NAME as SEO42_8_0_, this_.DEFAULT_RATE_NAME as DEFAULT43_8_0_, this_.DEFAULT_RATE_DESCRIPTION as DEFAULT44_8_0_, this_.DEFAULT_TAXESEVICE_DESCRIPTION_ID as DEFAULT45_8_0_, this_.SEPARATE_PROMOTION_PACKAGE as SEPARATE46_8_0_, this_.HIDE_ROOM_NOT_AVAILABLE as HIDE47_8_0_, this_.ALLOTMENT_ALGORITHM as ALLOTMENT48_8_0_, this_.DEMO as DEMO8_0_, this_.PINNED as PINNED8_0_, this_.SCORE as SCORE8_0_, this_.SALE_AMOUNT as SALE52_8_0_, this_.ALLOTMENT_WARNING as ALLOTMENT53_8_0_, this_.FORCE_PREPAYMENT as FORCE54_8_0_, this_.FORCE_PREPAYMENT_PERCENT as FORCE55_8_0_, this_.OPTIONAL_CC_INFO as OPTIONAL56_8_0_, this_.LATITUDE as LATITUDE8_0_, this_.LONGITUDE as LONGITUDE8_0_, this_.HPA_ENABLED as HPA59_8_0_, this_.AUTO_EXPAND as AUTO60_8_0_, this_.AUTO_SEARCH as AUTO61_8_0_, this_.ENABLE_IP_TRACK as ENABLE62_8_0_, this_.LANDING_PROMOTION as LANDING63_8_0_, this_.ACCOMM_DESC as ACCOMM64_8_0_, this_.FACILITY_DESCRIPTION as FACILITY65_8_0_, this_.LOCATION_LINK as LOCATION66_8_0_, this_.LOCATION_DESCRIPTION as LOCATION67_8_0_, this_.CODE_LABEL as CODE68_8_0_, this_.CODE_BUTTON as CODE69_8_0_, this_.ENABLE_VIP as ENABLE70_8_0_, this_.ADVANCED_DEPOSIT as ADVANCED71_8_0_, this_.ADD_ENH_INTO_DEPO as ADD72_8_0_, this_.AP_USER as AP73_8_0_, this_.AP_PASS as AP74_8_0_, this_.VERSION as VERSION8_0_, this_.EXCLUDE_DEPOSIT_TAX as EXCLUDE76_8_0_, this_.HOTEL_LOGO as HOTEL77_8_0_, this_.HOTEL_MAP as HOTEL78_8_0_, this_.PORTAL_IMAGE as PORTAL79_8_0_, this_.HOTEL_SKIN_ID as HOTEL80_8_0_, this_.WEEKDAY as WEEKDAY8_0_, this_.WEEKEND as WEEKEND8_0_, this_.HOTEL_GROUP as HOTEL83_8_0_, this_.PARTNER_ID as PARTNER84_8_0_, this_.AREA as AREA8_0_, this_.PROVINCE as PROVINCE8_0_, this_.DISTRICT as DISTRICT8_0_, this_.SUB_DISTRICT as SUB88_8_0_, this_.CATEGORY as CATEGORY8_0_, this_.COUNTRY as COUNTRY8_0_ from HOTEL this_ where this_.PREFIX=?]; SQL state [HY000]; error code [1267]; Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='; nested exception is java.sql.SQLException: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='

« Back