SQL Built-In Functions And Stored Procedures

Feng Shui practice has become an important reference for the planning and design of buildings, monuments and even entire cities. In fact Feng Shui is an evolved study of the natural and built environm

Benny Chia’s memoir of life on the fringe is a vivacious slice of Hong Kong’s life and cultural development at a time of minimal institutional support. His colourful and anecdotal story will interest culture practitioners as well as the general reader curious about the Fringe Club and its role as a seedbed for local artists and as a venue for international ones, both functions championed by Benny at the helm of this small but important institution housed in a distinctive former ice house in Central. general reader curious about the Fringe Club and its role as a seedbed for local artists and as a venue for international ones, both functions championed by Benny at the helm of this small but important institution housed in a distinctive former ice house in Central.

Tobias Klein explores applications of 3D printing in architecture, art, design and interactive media installations in order to create a fusion of contemporary CAD/CAM technologies built from natural m

How do public markets, as ordinary as they seem, carry the weight of a city’s history? How do sucheveryday buildings reflect a city’s changing political, social, and economic needs, through their yearslong transformations in forms, functions, and management? Integrating architecture and history, this book invites readers to go through the growth and governance of colonial Hong Kong by tracing the past and present of public markets as a study of extensive firsthand historical materials. As the readers witness the changes in Hong Kong markets from hawker pitches to classical market halls to clean modernist municipal complexes, the book offers a new perspective of understanding the familiar everyday markets with historical contexts possibly unfamiliar to most, studying markets as a microcosm of the city and a capsule of its history. -------------- This book is a robust and in-depth study of the market building history of Hong Kong since the 1840s and contributes to a holistic un

Adaptive reuse refers to reusing an old building for a purpose other than which it was originally built or designed. This conservation approach has become increasingly popular around the world. Howeve

Modern architecture has become increasingly concerned about the integration and harmony between the natural and built environments. Terms like environmental protection and management, energy conservat

The inspiring, haunting story of Chinese migrant workers rejected by the USA who built a new community in Mexico.From the 1850s, as the United States pushed west, Chinese migrants met ordinary Americans for the first time. Alienation and xenophobia lost the US this chance for cultural and economic enrichment—but America gave the Chinese new perspectives, connections, and dreams of their own. As teenagers, Hugo Wong’s great-grandfathers fled poverty in Guangdong for California. A decade later, excluded from the US, they helped establish a Chinese settlement across the border in Mexico, led by a world-famous dissident-in-exile with visions of a New China overseas. They would be among the Americas’ first Chinese magnates, meeting with presidents, generals, and missionaries, living through astonishing victories and humiliating defeats. The bitterest of all would be the colony’s tragic demise amid a violent Mexican revolution, leading to the largest massacre and deportation of Chinese in Am

Revitalization in Asia: Adaptive Reuse in Macao, Mumbai, and Penang offers a clear understanding of the value of sustainable adaptive reuse within an Asian context. Three highly urbanized places (Macao, Mumbai, and Penang) are considered in detail from conservation and planning perspectives (with essays and timelines for each). For each place, five case studies offer a comparative framework for understanding similarities and differences in adaptive reuse projects. Six essays examine adaptive reuse in terms of its connection to the three dimensions of sustainability, with reference to the United Nations’ Sustainable Development Goals. This book is envisioned as a continuation of Asian Revitalization: Adaptive Reuse in Hong Kong, Shanghai, and Singapore.

In Christianity and Education in Modern China, Wong Man Kong, George Kam Wah Mak, and other contributors demonstrate how Christianity served as a driving force in the development of modern education in China. Each of the chapters offers new insights into Christian involvement in different issues concerning education in modern China. The contributors examine how Christian missionaries and Chinese Christian educators interacted with China’s social, cultural, and political contexts. Also explored are the Christian legacies of higher education in mainland China and Taiwan, as well as how the spirit of Christian higher education in modern China has been carried on in Asia. This volume suggests that Western missionary and Chinese Christian perspectives of higher education were complementary with each other in modern China.

Psychosis and Schizophrenia in Hong Kong covers some of the most serious mental health conditions that top the global disease burden and affect 3 per cent of the general population. However, most research on psychotic disorders is undertaken in the West, and few studies have been systematically carried out in Asia despite global interest in regional differences. This work offers a unique and coherent account of these disorders and their treatment in Hong Kong over the last thirty years.Chen and his research programme’s pioneering work has ranged from the impact of early intervention on outcomes and relapse prevention, to the renaming of psychosis to reduce stigma. The studies have contributed to wider international debates on the optimal management of the condition. Their investigations in semantics and cognition, as well as cognition-enhancing exercise interventions, have provided novel insights into deficits encountered in psychotic disorders and how they might be ameliorated. The re

Population ageing is a challenge to societies worldwide in terms of healthcare, social support, community infrastructure, and more. With one of the longest life expectancies in the world, Hong Kong will soon see a dramatic increase in the number of older residents together with a decrease in the old age dependency ratio. This book provides a timely examination of the current status and services available for Hong Kong’s ageing population in four key areas: general healthcare needs, such as health promotion and lifestyle modifications; specific healthcare needs, including care of chronic conditions and hip fractures; psychosocial needs for older people with intellectual disabilities and impairments, as well as the needs of their caregivers; and environmental and technological needs in relation to universal design, information and communication technology, and telehealth.Drawing from a wide range of experience in local professional settings combined with international best practices, the

An analysis of the lessons learned from tuberculosis control in Shanghai. Tuberculosis Control and Institutional Change in Shanghai, 1911-2011 is the first book on the most widespread and deadly infectious disease in China, both historically and today. Weaving together interviews with data from periodicals and local archives in Shanghai, Rachel Core examines the rise and fall of tuberculosis control in China from the 1950s to the 1990s. Under the socialist work unit system, the vast majority of people had guaranteed employment, a host of benefits tied to their workplace, and there was little mobility--factors that made the delivery of medical and public health services possible in both urban and rural areas. The dismantling of work units amid wider market reforms in the 1980s and 1990s led to the rise of temporary and casual employment and a huge migrant worker population, with little access to health care, creating new challenges in TB control. This study of Shanghai will provide valu

This book, the first of its kind in Hong Kong, offers insights from experts in healthcare and higher education both locally and further afield. Key learnings and recommendations are presented in three sections: disaster management and reconstruction, including what we can learn from past earthquakes; the importance of healthcare and emergency medicine in disasters and community events; and the way forward, in particular how technology and systems thinking can be used for disaster mitigation.

Studies in Colloquial Chinese and Its History: Dialect and Text presents cutting-edge research into issues regarding prestige colloquial languages in China in their spoken forms and as well as their relationship to written forms and the colloquial literary language. These include the standard regional languages and prestige dialects of the past, the influence of historical forms of spoken Chinese on written Chinese, the history of guānhuà and the history of báihuà, proto-dialects and supra-regional common languages (koines), and their relationship to spoken dialects. The various studies in this collection focus on the dialect groups with the most substantial written tradition, including Mandarin, Wu, Min, and Cantonese, in north, central and eastern coastal, and southern China respectively. The contributors explore the histories of these dialects in their written and spoken forms, presenting a variegated view of the history and development of the regional forms, including their evoluti

Masculinity, fast-changing and regularly declared to be in the throes of crisis, is attracting more popular and scholarly debate in China than ever before. At the same time, Chinese literature since 1989 has been characterized as brimming with countercultural ‘attitude’. This book probes the link between literary rebellion and manhood in China, showing how male writers, as they critique the outcomes of decades of market reform, also ask the same question: how best to be a man in the new postsocialist order?In this first full-length discussion of masculinity in post-1989 Chinese literature, Pamela Hunt offers a detailed analysis of four contemporary authors in particular: Zhu Wen, Feng Tang, Xu Zechen, and Han Han. In a series of insightful readings, she explores how all four writers show the same preoccupation with the figure of the man on the edges of society. Drawing on longstanding Chinese and global models of maverick and marginal masculinity, and responding to a desire to retain a

The present volume is a collection of selected papers of the international conference on “Translation and Modernization in East Asia in the 19th and Early 20th Centuries,” organized by the Research Ce

As a Cultural construct, gender is fictional and imagined, yet its ideological and representational effects on the formation of self and identity are quite real. The fiction behind the fictional, which many accepts as truth, is at the core of what is most intriguing about the problem of gender. Critiquing this narrative, Gender, Discourse, and the Self in Literature unravels the strategies that writers and filmmakers adopt in their (de)construction of the gendered self in three Chinese communities: mainland China, Taiwan, and Hong Kong. Writing from the vantage points of film, literature, and gender studies, contributors make an innovative marriage to Western gender discourse and the construction and representation of self and identity in contemporary China.

Escaping the End of Times is a book where history meets psychology. It invites readers to explore the intricate relationships between dreams, politics, and the Chinese writing system in early modern China.Thoroughly researched and written in an accessible manner, this book presents a series of historical encounters that reveal how Ming scholars countered instability by compiling and editing dream texts. Readers learn how these scholars translated their dreams into action, used the past to bolster their status, reaffirmed their preferred societal order, merged myth and history, and interpreted their dreams and the dreams of others through creative techniques grounded in scholarly tradition.By combining detailed research with captivating storytelling, this book not only brings the world of late Ming dream analysis to life but also demonstrates the relevance of the past to the stories we tell now about ourselves and our own dreams.

The third edition has undergone significant revisions from the second edition, which was published in 2011. Significant enhancements include coverage of　advancements in electronic commerce and financialtechnology (fintech), particularly the adoption of blockchain-based letters of credit and internet of things. Readers will gain valuable knowledge about trade developments in fintech, blockchain, and important trade promotion institutions in the Greater Bay Area.This book offers comprehensive and well-structured content, making it an excellent resource for training professionals such as bankers, import/export managers, and lawyers.It is particularly beneficial for students enrolled in the Finance of International Trade module of the Professional Diploma for Certified Banker offered by the Hong Kong Institute of Bankers, helping them prepare effectively for their examinations.

In Gentle Voices, Bold Strides, Professor Fanny Cheung shares her inspiring journey as a psychologist, academic leader, and champion of gender equality. Growing up in a traditional Hong Kong family, she recognized early injustices against women and dedicated her life to change.Pioneering gender studies in Asia and leading the Equal Opportunities Commission, she fought discrimination, domestic violence, and gender bias in policy and research. Her leadership reshaped academia and public policy through consensus-building and quiet determination, leaving a legacy of empowerment.By blending personal narratives with social history, this memoir serves as a testament to the power of advocacy and the quiet strength of those who strive to make a difference.

Written in Stone by Polo Bourieau is an extraordinary exploration of how monumental sculpture transforms urban spaces into places of meaning and connection. From the ancient marble quarries of Carrara to the skyscrapers of Hong Kong or the bustling lanes of Chengdu, this richly illustrated book charts Polo’s creative journey, offering profound insights into the dialogue between sculpture, architecture, and community.Structured as an epic narrative inspired by Joseph Campbell’s monomyth theory, Polo’s sculptures become the protagonists of our common narrative of adventure, transformation, and identity. With reflections on the creative process and a conversation with urban planner and design writer Catherine Shaw, the book delves into the challenges and realities of creating public art in the dynamic landscapes of 21st-century China.Written in Stone offers a philosophical meditation on the power of art to shape our cities and ourselves. It invites readers—whether city planners,

‘We must have a procedure – if we are going to hang anyone – that is just,’ said Chief Justice Sir Francis Piggott in 1909, on discovering that Chinese accused of murder were being denied interpretation in Hong Kong’s courts. Due process, no matter how costly or inconvenient, was ‘one of the penalties of empire,’ he declared.Penalties of Empire explores how judges, juries, and lawyers strove to deliver justice during the 150 years when the death penalty was in force in Hong Kong. Nine main chapters focus on key capital trials in the first century of British rule. Among the cases are piracies, assassinations, and crimes of passion and desperation. These chapters describe the proceedings in court and the participants involved. They also explore the debates surrounding each case and the exercise or denial of mercy by governors. Two final chapters discuss the decline of the death penalty after World War II, its suspension after 1966, and the controversies leading to its formal abolition in

Asian Celebrity Cultures in the Digital Age represents the first comprehensive study on the transformations of celebrity cultures in increasingly globalised and digitalised Asian societies. It discusses relations between Asian celebrities and digital media across emerging phenomena in celebrity practices, cultures, politics, fandom, and economies. Highlighting original case studies from prominent Asian societies, including India, China, Hong Kong, the Philippines, Singapore, Vietnam, Indonesia, Thailand, South Korea, and Japan, this book sheds much-needed light on the de-Westernisation and internationalisation of celebrity studies and is essential reading for scholars and students in celebrity, fandom, digital media and communication, and cultural studies.

In A New Documentary History of Hong Kong, 1945–1997, Florence Mok, Fung Chi Keung Charles, and other contributors analyse newly released archival records from the National Archives in London, the Government Records Service in Hong Kong, and other sources across the world. This documentary collection provides an updated and improved understanding of basic aspects of the city such as governance, economy, society, and culture. It also aims at investigating topics that are under-exploited in previous sourcebooks, such as race and diasporas, gender and familial relations, medicine and healthcare, and environment and natural disasters. Overall, this book offers an innovative and comprehensive long-term perspective of Hong Kong’s colonial history.

In an epic historical story that talks directly to our times, Cross and Dragon dramatizes the life of one of the most famous Western figures in China: Italian Jesuit Matteo Ricci. Sent by the Pope in the late 16th century to convert the Chinese Emperor, Ricci was faced with a “mission impossible” as China in the Ming Dynasty did not allow foreigners to enter the country.

In Lu Xun and World Literature, Xiaolu Ma, Carlos Rojas, and other contributors examine various aspects of Lu Xun, who is known as the father of modern Chinese literature. Essays in this book focus on Lu Xun’s works in relation to the notions of world literature and processes of literary worlding. The contributors offer detailed analyses of Lu Xun’s own literary oeuvre and of foreign works that engage with his writings. This volume also focuses on many facets of the publication and dissemination of Lu Xun’s works’, from printing and binding to the discussions and debates that followed their release in China and abroad. This book not only makes an important contribution to the field of Lu Xun studies, but also proposes a reexamination of the category of world literature.

In Socializing Medicine, Pao-chen Tang, Yuqian Yan, and Ling Zhang explore the intersections of medicine, health, and East Asian media. Interweaving archival research, audiovisual analyses, and theoretical insights from the emerging field of health humanities, the book reveals the multifaceted ways in which the mass media—from photography and film to television and live streaming—has been deployed as a tool for controlling medicine and health, privileging those with power and authority from the early twentieth century to the present. Adopting anti-colonial and anti-capitalist perspectives, the contributors in this volume challenge the dominant mediations of health against the backdrop of imperialism, Cold War geopolitical tensions, and neoliberal capitalism. Collectively, they advocate for alternative understandings of medical culture through media productions that envision accessible and equitable healthcare practices.

This volume is a translated and edited collection of studies on the Shi ji (Records of the historian) by SimaQian, authored by the prestigious Japanese sinologist Miyazaki Ichisada. Providing a pathbreaking analysis of the structure and formation of the Shi ji, it serves not only as an excellent introduction to Sima Qian’s masterpiece but also offers historiographical and methodological insights that will stimulate further debate and research.In this volume, Miyazaki presents fascinating evidence of the influence of narrative fiction and drama in Sima Qian’s recreation of the entire length and breadth of Chinese history right up to his own time. By establishing a foundational model for writing comprehensive histories in China, Sima Qian’s work is essential for understanding the subsequent tradition of historical writing. This volume offers readers valuable insights into how Sima Qian constructed his seminal work.A monument of Japanese scholarship on the Shi ji, Prof. Miyazaki Ichisada’

Wisdom means learning to live with ambivalence and to embrace uncertaintyHelga Nowotny’s memoir provides a detailed account of her life, highlighting the challenges and triumphs of a woman who defied convention in the male-dominated field of science. From her early days in science and technology studies, where she faced bureaucratic hurdles, to her influential role in shaping the European Research Council, Nowotny offers a candid look at her career. She shares personal stories of navigating the complexities of academia and policy, revealing the uncertainties and contingencies that shaped her life and work. This memoir resonates with anyone who has pursued a path less traveled, and offers a glimpse into the resilience and ambition required to succeed in challenging environments.Future Needs Wisdom is not really a memoir, nor is it an intellectual history, nor is it entirely a personalreflection or a summative philosophy. It is, in fact, all of these things fused together: her life, her

Most histories of Hong Kong begin with the arrival of the British, and only incidentally mention the precolonial eras. In this book, Patrick Hase, one of the leaders in the field, provides an important addition to the history of Hong Kong and the Pearl River Delta region, covering topics such as Chinese ethnicity, commerce, port-towns, and squatting. It is a truly excellent work that will interest historians, anthropologists, and social scientists.—James L. WatsonFairbank Professor of Chinese Society and Anthropology Emeritus,Harvard UniversityThis book, an historical and archaeological portrayal of Hong Kong market villages across the territory, depicts how Hong Kong evolved not through chronicles of emperors and governors but through the ups and downs of different centres of rural life over the centuries. It belongs beyond the bookshelves of historians and archaeologists—anyone wandering the streets of Hong Kong neighbourhoods today wondering “how did this place get to be here?” wil

This book examines the British cultural engagement with Hong Kong in the second half of the twentieth century. It shows how the territory fit unusually within Britain’s decolonisation narratives and served as an occasional foil for examining Britain’s own culture during a period of perceived stagnation and decline. Drawing on a wide range of archival and published primary sources, Hong Kong and British Culture, 1945–97 investigates such themes as Hong Kong as a site of unrestrained capitalism, modernisation, and good government, as well as an arena of male social and sexual opportunity. It also examines the ways in which Hong Kong Chinese embraced British culture, and the competing predictions that British observers made concerning the colony’s return to Chinese sovereignty. An epilogue considers the enduring legacy of British colonialism.

With an increasing concern of personal data privacy in Hong Kong and around the world, the Office of the Privacy Commissioner for Personal Data (PCPD), Hong Kong publishes this third edition of Personal Data (Privacy) Law in Hong Kong: A Practical Guide on Compliance to provide practical guidance on the law of privacy, and the ways to protect personal data in everyday life.This third edition will guide readers through the recent developments of personal data privacy in the local, regional and global contexts with updates on recent Administrative Appeals Board and Court decisions, and investigation reports and materials from the PCPD. In addition, some most-concerned issues are discussed, such as ethical development and use of AI, the collection and use of personal data by employers during COVID-19, data protection under work-from-home arrangements, data security measures for ICT systems, guidelines on doxxing offences and data breach handling. This book will certainly provide readers a

How did lay people in old China save their lives when dealing with acute or chronic health issues? Conventional medicine was costly and might not have been an option for many. Instead, people in villages and towns relied on remedies drawn from a woodblock-printed illustrated booklet called the Seventy-Two Therapies, first published in 1847. The goal of this book is to foster an appreciation of China’s long tradition of folk remedies. Each folk remedy is illustrated by a page from the circa 1860s woodblock edition of the Seventy-Two Therapies which the author used for translation. He also added a historical and interpretive analysis to expand on each therapy and to place it in the context of contemporary thinking, aiming at academics and readers interested in the everyday lives of common people in pre-1950 China, and in the folk medicine wisdom inherited from the past. ------------------------------------------------------------------------------- “The 72 specific disease

From humble beginnings in Hong Kong, Yuen Kwok-Yung rose to international prominence as an academic, physician, and microbiologist. As an advisor to governments, he and colleagues made discoveries that helped the world cope in often controversial ways with unprecedented threats to public health, including the COVID-19 pandemic. In this compelling memoir, Dr. Yuen weaves personal stories with those from his extraordinary medical careers to take readers on an inspiring journey about perseverance, courage, faith, and the ongoing peril of infectious diseases. threats to public health, including the COVID-19 pandemic. In this compelling memoir, Dr. Yuen weaves personal stories with those from his extraordinary medical careers to take readers on an inspiring journey about perseverance, courage, faith, and the ongoing peril of infectious diseases.

In The New Politics of Beijing–Hong Kong Relations, Sonny Shiu-Hing Lo looks at the diverging changes to the ideologies from both Beijing and Hong Kong, and the ideological conflicts as taken in the form of factional political struggles between 2012 and the present. This book examines the paternalistic authoritarianism that can be seen in Beijing’s policy toward Hong Kong since the promulgation of the national security law in late June 2020. Lo analyzes the ideological shift from liberal nationalism to conservative nationalism in mainland China, which has taken place since late 2012. The increasingly radical localism in Hong Kong after 2014 transformed Beijing–Hong Kong relations into a conflict-ridden situation characterized by factional struggles. While the imposition of the national security law into Hong Kong since late June 2020 has stabilized the city politically, Beijing’s policy toward Hong Kong is now guided by the principles of protecting its national security and m

This fourth edition of Contract Law in Hong Kong is a comprehensive contemporary textbook on Hong Kong contract law written primarily for law students. The sixteen chapters of the book cover all basic contract concepts in a reader-friendly style and make ample use of case illustrations, including over 200 new cases in this new edition. The book deals with all the core areas of contract law. New legislative rules, notably the Contracts (Rights of Third Parties) Ordinance, have also been covered.The first two chapters introduce the major themes and explain the multiple sources of law in Hong Kong. The subsequent thirteen chapters cover the formation of a valid contract, its contents, “vitiating” elements, the consequences of illegality, the termination of contracts, and remedies for breach of contract. The book concludes with an explanation of the doctrine of privity and the legislative reform of the operation of privity in Hong Kong. Particular attention is given to what makes

Following the ending of the First Opium War and the signing of the Treaty of Nanjing in 1842, Britain opened five treaty ports on the Chinese mainland in the cities now known as Fuzhou, Guangzhou, Ningbo, Shanghai, and Xiamen. Foreigners were allowed for the first time to live and work normally in these cities under the eyes of their state’s consul. In establishing this presence, consular staff and their families faced numerous challenges, including unsuitable accommodation, illness, hostile local authorities, attacks from militias and pirates, while at the same time adjusting to an unfamiliar language and culture.Henrietta Alcock (1812–1853), the first wife of the British Consul, Rutherford Alcock, was little-known until an album of sketches and watercolours depicting her life in China came to light. Acquired by the Martyn Gregory Gallery, London in the early 1990s, the works in the Alcock Album feature picturesque natural landscapes, traditional Chinese architecture, and scenes of co

The COVID-19 pandemic was a global crisis that affected millions of lives and brought mental health challenges to the forefront. In Hong Kong, the situation was worsened by uniquely strict COVID-19 regulations, quarantine measures, and travel restrictions. The mental health issues associated with the pandemic did not end with the lifting of the mask mandate. On the contrary, the repercussions are only just beginning to surface and their impact will be felt for years to come.This eye-opening book tells the stories of ordinary Hongkongers who faced extraordinary challenges during the pandemic. Through a blend of first-person accounts, psychological insights, and hard data, it offers a compelling and accessible exploration of the toll that the COVID-19 pandemic has taken on mental health in Hong Kong.However, this book is not only a chronicle of suffering; it is also a guide to healing and hope. It offers practical advice on how to overcome the mental health issues caused by the pandemic,

Form Follows Fever is the first in-depth account of the turbulent early years of settlement and growth of colonial Hong Kong across the 1840s. During this period, the island gained a terrible reputation as a diseased and deadly location. Malaria, then perceived as a mysterious vapour or miasma, intermittently carried off settlers by the hundreds. Various attempts to arrest its effects acted as a catalyst, reconfiguring both the city’s physical and political landscape, though not necessarily for the better. Caught in a frenzy to rebuild the city in the devastating aftermath, this book charts the complex interplay between a cast of figures, from military surveyors, naval doctors, Indian sepoys, and corrupt and paranoid officials to opium traders, arsonists, Chinese contractors, and sojourner architects and artists. However, Hong Kong’s ‘construction’ was not just physical but also imagined. Architecture, cartography, epidemiology, and urban infrastructure offer a critical forensic l

In Rosie Young: A Lifetime of Selfless Service, Moira Chan-Yeung presents a brief history of Professor Young’s remarkable career in medical education and administration at the University of Hong Kong (HKU) and her wide-ranging public service to the community over many decades. As the first female dean of HKU’s Faculty of Medicine, her career was deeply intertwined with the socio-economic development of Hong Kong. After her retirement from HKU, she continued to serve HKU and the community up to the present. This book illustrates her many contributions to the development of medical education in Hong Kong and to the university administration at HKU. Professor Young’s extensive public service in the field of medicine also helped improve primary care, hospital care, and public health in Hong Kong. In short, this book provides a valuable record of a female giant in Hong Kong’s medical history and documents her selfless and enduring service to the HKU community and Hong Kong society.