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_.ORDER_OPTION as ORDER19_8_0_, this_.ORDER_DIRECTION as ORDER20_8_0_, this_.SEARCH_TREATMENT as SEARCH21_8_0_, this_.PERCENT_PAYMENT as PERCENT22_8_0_, this_.COMMISSION as COMMISSION8_0_, this_.PROMOTION_POINT as PROMOTION24_8_0_, this_.GATEWAY as GATEWAY8_0_, this_.GATEWAY_REF_NO_1 as GATEWAY26_8_0_, this_.GATEWAY_REF_NO_2 as GATEWAY27_8_0_, this_.GATEWAY_REF_NO_3 as GATEWAY28_8_0_, this_.GATEWAY_REF_NO_4 as GATEWAY29_8_0_, this_.GATEWAY_REF_NO_5 as GATEWAY30_8_0_, this_.BN_CODE as BN31_8_0_, this_.GATEWAY_URL as GATEWAY32_8_0_, this_.CREATED_DATE as CREATED33_8_0_, this_.UPDATED_DATE as UPDATED34_8_0_, this_.CREATED_BY as CREATED35_8_0_, this_.UPDATED_BY as UPDATED36_8_0_, this_.PUBLIC_KEY as PUBLIC37_8_0_, this_.CUSTOM_PAYMENT_GATEWAY as CUSTOM38_8_0_, this_.CURRENCY as CURRENCY8_0_, this_.LANGUAGE as LANGUAGE8_0_, this_.SEO_NAME as SEO41_8_0_, this_.DEFAULT_RATE_NAME as DEFAULT42_8_0_, this_.DEFAULT_RATE_DESCRIPTION as DEFAULT43_8_0_, this_.DEFAULT_TAXESEVICE_DESCRIPTION_ID as DEFAULT44_8_0_, this_.SEPARATE_PROMOTION_PACKAGE as SEPARATE45_8_0_, this_.HIDE_ROOM_NOT_AVAILABLE as HIDE46_8_0_, this_.ALLOTMENT_ALGORITHM as ALLOTMENT47_8_0_, this_.DEMO as DEMO8_0_, this_.PINNED as PINNED8_0_, this_.SCORE as SCORE8_0_, this_.SALE_AMOUNT as SALE51_8_0_, this_.ALLOTMENT_WARNING as ALLOTMENT52_8_0_, this_.FORCE_PREPAYMENT as FORCE53_8_0_, this_.FORCE_PREPAYMENT_PERCENT as FORCE54_8_0_, this_.OPTIONAL_CC_INFO as OPTIONAL55_8_0_, this_.LATITUDE as LATITUDE8_0_, this_.LONGITUDE as LONGITUDE8_0_, this_.HPA_ENABLED as HPA58_8_0_, this_.AUTO_EXPAND as AUTO59_8_0_, this_.AUTO_SEARCH as AUTO60_8_0_, this_.ENABLE_IP_TRACK as ENABLE61_8_0_, this_.LANDING_PROMOTION as LANDING62_8_0_, this_.ACCOMM_DESC as ACCOMM63_8_0_, this_.FACILITY_DESCRIPTION as FACILITY64_8_0_, this_.LOCATION_LINK as LOCATION65_8_0_, this_.LOCATION_DESCRIPTION as LOCATION66_8_0_, this_.CODE_LABEL as CODE67_8_0_, this_.CODE_BUTTON as CODE68_8_0_, this_.ENABLE_VIP as ENABLE69_8_0_, this_.ADVANCED_DEPOSIT as ADVANCED70_8_0_, this_.ADD_ENH_INTO_DEPO as ADD71_8_0_, this_.AP_USER as AP72_8_0_, this_.AP_PASS as AP73_8_0_, this_.VERSION as VERSION8_0_, this_.EXCLUDE_DEPOSIT_TAX as EXCLUDE75_8_0_, this_.HOTEL_LOGO as HOTEL76_8_0_, this_.HOTEL_MAP as HOTEL77_8_0_, this_.PORTAL_IMAGE as PORTAL78_8_0_, this_.HOTEL_SKIN_ID as HOTEL79_8_0_, this_.WEEKDAY as WEEKDAY8_0_, this_.WEEKEND as WEEKEND8_0_, this_.HOTEL_GROUP as HOTEL82_8_0_, this_.PARTNER_ID as PARTNER83_8_0_, this_.AREA as AREA8_0_, this_.PROVINCE as PROVINCE8_0_, this_.DISTRICT as DISTRICT8_0_, this_.SUB_DISTRICT as SUB87_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